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

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




  2. #2
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    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
  •