Omg, what a dumb mistake, I should have known that...thnx -----Original Message----- From: Bostrup, Tore [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 12:11 PM To: ActiveServerPages Subject: RE: Unknow SQL Update error
TEXT is a reserved word in MS Access. Use [text] instead. HTH, Tore. -----Original Message----- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:11 AM To: ActiveServerPages Subject: Unknow SQL Update error 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.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
