Microsoft OLE DB Provider for ODBC Drivers

[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

[aspnetguy]

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