Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Script thinks that record isn't there, but it is...

    Problem Fixed, there was a linebreak in one of the fields.
    Last edited by weevaa; 10-17-03 at 21:58.

  2. #2
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72
    I suppose that the execute method has a parameter so as to raise an error when it fails, i think that this parameter has a default so as not to raise errors.

    You can try it by passing to the execute method an incorrect sql string or an incorrect data in your INSERT string so as to test if it is raising errors.

    Hope it helps

  3. #3
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721

    Re: Script thinks that record isn't there, but it is...

    Originally posted by weevaa
    auction_refdb = RS("AUCTION_REF")
    Before you pull data from a RS, make sure it has something in it:

    Code:
    If NOT RS.BOF AND NOT RS.EOF Then
      auction_refdb = RS("AUCTION_REF")
      .
      .
      .
    Else
      Response.Write "No records were found."
    End If
    Now, if you know for a fact the record exists.. it could be that the case they type the email address in is different.

    myemail@domain.com
    is diffeent then:
    MyEmail@domain.com
    (when using SQL)

    Try the "LIKE" statement... WHERE BUYER_EMAIL LIKE '" & buyer_emailform & "'"
    That which does not kill me postpones the inevitable.

Posting Permissions

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