» select - Organize and share your code snippets

Tag Archive for select

snippets | February 2, 2012

mysql select query

SELECT column_names FROM table_name WHERE conditions

source

Category: Uncategorized | Tags: mysql, query, select, textmate

snippets | January 25, 2012

No comments

Birth Year Dropdown

<select id="birthyear" name="birthyear">
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
<option value="1929">1929</option>
<option value="1928">1928</option>
<option value="1927">1927</option>
<option value="1926">1926</option>
<option value="1925">1925</option>
<option value="1924">1924</option>
<option value="1923">1923</option>
<option value="1922">1922</option>
<option value="1921">1921</option>
<option value="1920">1920</option>
<option value="1919">1919</option>
<option value="1918">1918</option>
<option value="1917">1917</option>
<option value="1916">1916</option>
<option value="1915">1915</option>
<option value="1914">1914</option>
<option value="1913">1913</option>
<option value="1912">1912</option>
<option value="1911">1911</option>
<option value="1910">1910</option>
<option value="1909">1909</option>
<option value="1908">1908</option>
<option value="1907">1907</option>
<option value="1906">1906</option>
<option value="1905">1905</option>
<option value="1904">1904</option>
<option value="1903">1903</option>
<option value="1902">1902</option>
<option value="1901">1901</option>
<option value="1900">1900</option>
</select>

source

Category: Uncategorized | Tags: birthday, down, drop, select, year

snippets | January 24, 2012

No comments

simule z-index to place divs over select objects (explorer bug)

INSIDE THE HEAD
......................................................................
<script type="text/javascript" src="http://brandonaaron.net/jquery/plugins/bgiframe/jquery.bgiframe.js"></script>

<script type="text/javascript">
$(function() {
$('#box').bgiframe();
});
</script>

<style type="text/css" media="screen">
form { position: absolute; top: 0; left: 0; width: 100%; }
select { position: relative; width: 100%; margin: 0 0 2px; z-index: 1; }
.box { position: relative; z-index: 2; float: left; margin: 5px; border: 5px solid #666; padding: 5px; width: 250px; height: 100px; color: #000; background-color: #999; }
</style>

HTML
......................................................................
<form action="#" method="get" accept-charset="utf-8">
<select name="test"><option>valor 1</option></select>
<select name="test"><option>valor 2</option></select>
<select name="test"><option>valor 3</option></select>
</form>
<div id="box" class="box">contenido del box</div>

source

Category: Uncategorized | Tags: div, form, select, z-index

snippets | January 24, 2012

No comments

Select ajax DOM Fill

<html>
<head>
<title>Select ajax DOM Fill</title>
<script type="text/javascript" src="XHConn.js"></script>
</head>
<body>
<script type="text/javascript">
function fill( ) {
var fnCarica = function (oGet) {
objSelect = document.getElementById('elemento-select') ;
var sJSON = oGet.responseText;

var oJSON = eval(sJSON);
var nOpt
for( nOpt=0;nOpt<oJSON.length;nOpt++) {
objSelect.options[objSelect.options.length] = new Option( oJSON[nOpt].text , oJSON[nOpt].value )
};
};
new XHConn().connect('fill.txt', 'GET', '' , fnCarica);
}
</script>
<select id="elemento-select">
<option value="valore1">etichetta1</option>
<option value="valore2">etichetta2</option>
<option value="valore3">etichetta3</option>
</select>
<button onclick="fill()">bau</button>
</body>
</html>

source

Category: Uncategorized | Tags: ajax, Fill, select

snippets | January 22, 2012

No comments

Ordering multiple SELECT statements in a UNION

(SELECT a FROM t1 WHERE a=10 AND B=1)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2)
ORDER BY a LIMIT 10;

source

Category: Uncategorized | Tags: BY, database, mysql, order, ordering, select, sql, UNION

snippets | December 26, 2011

No comments

Focus and Select a Form Input

/** @id codeFocus
* @classDescription Focuses on the selected input and selects the value text.
*/
var postcodeFocus = {
grab:function(){
if(!document.getElementById){return;};
if(!document.getElementById('selected')){return;};
var theInput = document.getElementById('selected');
theInput.focus();
theInput.select();
}
}

source

Category: Uncategorized | Tags: focus, form, select

snippets | December 26, 2011

No comments

Sort the OPTIONs in a SELECT menu

function compareOptionText(a,b) {
/*
* return >0 if a>b
*         0 if a=b
*        <0 if a<b
*/
// textual comparison
return a.text!=b.text ? a.text<b.text ? -1 : 1 : 0;
// numerical comparison
//  return a.text - b.text;

}

function sortOptions(list) {
var items = list.options.length;
// create array and make copies of options in list
var tmpArray = new Array(items);
for ( i=0; i<items; i++ )
tmpArray[i] = new
Option(list.options[i].text,list.options[i].value);
// sort options using given function
tmpArray.sort(compareOptionText);
// make copies of sorted options back to list
for ( i=0; i<items; i++ )
list.options[i] = new Option(tmpArray[i].text,tmpArray[i].value);

}

source

Category: Uncategorized | Tags: clj, dhtml, forms, javascript, library, menu, options, select, sort, utilities

snippets | December 15, 2011

No comments

Select

<div class="dropdown"><label for="$1">$2:</label><select id="$1" name="$1">
<optgroup label="$3">
<option value="$4" ${5:selected="selected"}>$6</option>
<option value="$7">$8</option>
</optgroup>
</select></div>

source

Category: Uncategorized | Tags: forms, html, select

snippets | December 4, 2011

No comments

copy selected text

function getSelectedText(){
if (window.getSelection){
txt = window.getSelection();
}
else if (document.getSelection) {
txt = document.getSelection();
}
else if (document.selection){
txt = document.selection.createRange().text;
}
else return;
return txt;
}

source

Category: Uncategorized | Tags: copy, interactive, select, text

« Older Entries

snippetsmania.comPost and share your code snippets

Tag Archive for select

Popular tags

snippetsmania.com
Post and share your code snippets