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]
