http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ mdmthcnnexecute.asp
shows the second parameter of the connection object's .Execute() method is a Long (actually a ByRef argument, the Long gets populated with the recordsAffected) Does this query run directly in your MDB? As a queryDef? David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Tim [mailto:[EMAIL PROTECTED]] Hopefully this post will not appear 2x, it keeps being rejected from the ListSeerv. I'm not a newbie, but damned if i can find my booboo here. I get this error.. "Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in UPDATE statement. /Admin/news.asp, line 201" here's a Response.Write of my SQL "UPDATE News SET entry_date = #8/8/2002 10:56:02 AM#, title = 'Mens B National Champions Blyth Storm, Blyth, O', text = 'Congratulations to Blyth Storm, Blyth Ontario - 2002 Champs!!' WHERE (Entry_id = 2)" here's my actual String... strSQL = "UPDATE News SET " _ & "entry_date = #" & sEntry_Date & "#, " _ & "title = '" & sTitle & "', " _ & "text = '" & stext & "' " _ & "WHERE (Entry_id = " & iRecordId & ")" Set cnnDBEdit = Server.CreateObject("ADODB.Connection") cnnDBEdit.Open CONN_STRING cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or adExecuteNoRecords --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
