var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query not giving the result in ASP as SQL plus giving
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
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