SQL Update of Memo field
Posted on 2003-03-02
How do I update an Access 2000 "Memo" field using SQL?
I am trying to edit an Access database using ASP/ADO, and every time I try to save a <textarea> form field using a SQL Update statement, I get the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/d2/admin/modpage.asp, line 194
If I replace the <textarea> with a textbox input, this doesn't help. If I hard-code a string (eg "test") into the script, I still get the error.
Concatenating strings doesn't help.
The relevant bit of code is:
sqlUpdateText = "UPDATE Page SET Text = '" & Request.Form("edit_text") & "' WHERE Page_ID = " & this_edit_id & " "
this_edit_id is the page numer that I want to edit. I'm sure there's no problem with this bit, as I use it for several SQL statements, which don't throw errors.
Request.Form("edit_text") is the <textarea>. -- This is where the prblem lies.
Any ideas? Thanks...