Database =Orcale 8i



here is the code

set rsn = Server.CreateObject("ADODB.Recordset")

set rsn=db.Execute("select SB_EMP_PERNO from v_shabash_empl where SB_DATE > '01-SEP-2004' ")



<%
Do While Not rsn.EOF
For I = 0 To rsn.Fields.Count - 1
Response.Write rsn(I)
Next
Response.Write "<BR>"
rsn.MoveNext
Loop

rsn.Close
%>



it giving all the PNO. No where condition working as it should gives only those PNO where

SB_date is greater than 01-SEP-2004



the same query is running in SQL plus giving the true value.



i don't understand where is the problem may be date format.



plz help me as soon as possible otherwise my boss will fired me....

is the format of SB_DATE dd-MMM-yyyy , if not it might return all the values

i would test the code by doing
"select SB_DATE from v_shabash_empl"
Just to make sure the date format is the same