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

weevaa · #1 (**permalink**) 10-17-03, 03:58

Problem Fixed, there was a linebreak in one of the fields.

fhunth · #2 (**permalink**) 10-17-03, 10:57

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

Seppuku · #3 (**permalink**) 10-17-03, 14:09

Quote:

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 & "'"

Internet Services

Web Development

Digital Marketing

Consumer Tech