[KCFusion] update syntax error

[Chris Holdman]

Title: Message

I have a simple acces database that I am trying to update.  I was using cfupdate (I know everyone hates it) so I changed to using a cfquery and using SQL to update.  The field I am updating is generated from people copying and pasting from word so I was getting all kinds of boxes and ?s instead of the single quotes and double quotes.  I found a niucfty little script to replace the bad characters, but when I try to update the database I get a syntax error now.  Here is the update code:

<CFSCRIPT>
function killcurly(formval){
var outval = formval;
outval = replace(outval,chr(8220),chr(34)); // replace left Curly double quote
outval = replace(outval,chr(8221),chr(34)); // replace right double quote
outval = replace(outval,chr(8216),chr(39)); // replace left Curly single quote
outval = replace(outval,chr(8217),chr(39)); // replace right Curly singe quote
outval = replace(outval,chr(8230),'...'); // replace MS ellipsis with three periods
outval = replace(outval,chr(8211),'-'); // replace MS em dash with ASCII dash
outval = replace(outval,chr(10),' '); // optionally get rid of line break
outval = replace(outval,chr(13),' '); //optionally get rid of carraige return
return outval;
}
</CFSCRIPT>

<CFQUERY NAME="insertdata" DATASOURCE="laura" DBTYPE="ODBC">
UPDATE reviews
(ID,reviewer,description)
VALUES(#ID#,#reviewer#,#killcurly(form.description)#)
</CFQUERY>

Here is the error generated:

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

The error occurred in D:\Webserver\laurachalk.com\www\admin\review_edit_pro.cfm: line 20

18 : UPDATE reviews 19 : (ID, reviewer,description) 20 : VALUES(#ID#,#reviewer#,#killcurly(form.description)#) 21 : </CFQUERY> 22 : UPDATE reviews (ID, reviewer,description) VALUES(23,Roger Atkinson, JAM Magazine, June/July 2004,My Favorite Things is Laura Chalk's debut recording, and it proves to be enjoyable. Backed by the stellar Danny Embrey (Danny also arranged all of the tunes except for the title cut), Paul Smith, Bob Bowman, and Todd Strait (with Rod Fleeman bringing his acoustic guitar to several tracks), Laura brings her clear voice to a program of bossa novas, ballads, and standards.)  DATASOURCE              lauraVENDORERRORCODE      -3503 SQLSTATE                  42000  What am I doing wrong?

 

Christopher V. Holdman

Webmaster - City of Olathe

work: 913.971.6286

cell: 913.238.4681