>How will add with my query.
>SELECT scode,CODE,descr,fname,descru,fnameu,lcode,sec,sex,rtel FROM student WHERE admtd=1;
>aND lcode>=thisform.lcodefm.value AND lcode<=thisform.lcodeto.value...
lnSex = thisform.Options1.Value
lcCoderFrom = thisform.lcodefm.value
lcCoderTo = thisform.lcodeto.value
SELECT scode ,;
CODE ,;
descr ,;
fname ,;
descru,;
fnameu,;
lcode ,;
sec ,;
sex ,;
rtel ;
FROM student ;
WHERE admtd == 1 AND;
lcode BETWEEN lcCoderFrom AND lcCoderTo AND;
(Sex = lnSex OR lnSex = 3)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
