Is price a number datatype? If so try removing the single quotes from '#price#' Tim P. ----- Original Message ----- From: "Jeff Fongemie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, May 05, 2001 6:57 PM 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