WHat is the syntax error? I would guess that one of your fields is not a TEXT field - maybe Price ? If any of those fields are numeric it will get messed up - or if your Price field is a money type and you are putting in a entry with a $ dollar sign? -----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 05, 2001 3:58 PM To: CF-Talk Subject: anyone see what is causing a Syntax Error is this update statement?? Hello cf-talk, This simple update is generating a syntax error i can't seem to resolve. What am I missing?? <cfquery DATASOURCE="#Application.dsn#"> UPDATE #form.table# SET name='#name#', desc='#desc#', price='#price#' WHERE id=#form.id# </cfquery> Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] ------------------------ Internet Guns For Hire (603) 356-0768 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists