Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unhappy 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
    Response.Write rsn(I)
    Response.Write "<BR>"


    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....

  2. #2
    Join Date
    Jan 2003
    New York
    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
    Beyond Limitation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts