Zmiana wartości opcji selecta

$('#right table td input[name=imie]').parent().parent().parent().css({'display':'none'});
$('#right table .teh').parent().parent().parent().parent().css({'display':'none'});
$('#right table td select[name=stanowisko] option:eq(0)').replaceWith("Zamiana wartości text");
$('#right table td select[name=stanowisko]').parent().prev().html('Zmiana tytułu labela nad selectem taki');
$('#right table td select[name=stanowisko]').val('0');

Sprawdzenie czy w querystringu istnieje parametr

var search=unescape(window.location.search);
if(search=='') {
} else {
var re = new RegExp('&b=(.?)','ig');
var tmp=re.exec(search);
var re_b='';
if(tmp!=null) {
re_b=tmp[1];
$('#right td select[name=b]').val(re_b);
}
}

<input value=”mapa Lublin” id=”mapa” class=”w500″ onClick=”this.select()”>

select t_add_date, SUBSTRING(t_add_date::character varying, 1, 19) from table where t_add_date < NOW()-'1 DAY'::interval
t_add_date substring
2010-03-10 21:26:49.928445 2010-03-10 21:26:49
2010-03-10 21:26:49.928445 2010-03-10 21:26:49

SELECT ROUND(liczba, 2) AS liczba1, ROUND(liczba, 4) AS liczba2 FROM tabela

select * from table where t_add_date < NOW()-’5 MONTH’::interval
select * from table where t_add_date < NOW()+’5 MONTH’::interval
select * from table where t_add_date < NOW()-’1 DAY’::interval
select * from table where t_add_date < NOW()-’2 DAYS’::interval

select * from table where t_add_date < NOW()-’1 DAY’::interval
select * from table where t_add_date < NOW()-’5 MINUTES’::interval

select * from table where t_add_date < NOW()-’3 HOURS’::interval

select SUBSTRING(schemat,’^(.+),’) from tabela_schematy
Dane:
public,data
Wynik:
public

var f = document.f2;
f.elements[i].options[Math.floor((f.elements[i].length-1)*Math.random())+1].selected=true;

GRANT usage ON schema moj TO moj_uzytkownik;
GRANT SELECT ON TABLE moj.tabela TO moj_uzytkownik;

select lower(replace(nazwa,’ ‘, ‘_’)) from nazwy

« poprzednie