Jump to content

Microsoft OLE DB Provider for ODBC Drivers


Guest peterpan
 Share

Recommended Posts

Guest peterpan

For some raison I got this error and I cannot find out why--- My Codes ---Line 25> set objrs = server.createobject("adodb.recordset") Line 26> objrs.activeconnection = objcLine 27> SQL = "UPDATE login SET login_date='"&date()&"', first_time=TRUE WHERE email='"&email&"' AND AuctionNumber='"&AuctionNumber&"'"Line 28> objrs.Open SQL, objc,3,3--- Error Message ---# Type d'erreur :Microsoft OLE DB Provider for ODBC Drivers/ebay/check.asp, line 28# Type de navigateur :Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2# Page :POST 23 octets à /ebay/check.asp# POST Data:AuctionNumber=1&email=1# Heure :samedi 22 avril 2006, 12:34:52

Link to comment
Share on other sites

it is either a problem with your connection string , but most likely, it is an erro in your SQL statement.The firls first_time....what datatype is it???Boolean???? I think you need to use 1 for TRUE and 0 for FALSE.tryfirst_time=1

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...