Sorry for the delay, I've been out of the office since Monday. Thanks again for all the help you've given me so far, it's really appreciated. Back on topic, I changed the line to add in the preservesinglequotes, and the error message changed to: "Syntax error (missing operator) in query expression 'Drive = C:'." The missing single quote before the C: is now gone, but there is still an error. It's finally generating something a little more detailed, however (missing operator). I'm not sure exactly what I'm missing, though, any ideas? Tarvalon
>Hmmm, interesting. The single quotes would be causing an error, but they >might just be part of the error message output. That is why I wanted to >you use CFQueryParam (which handles this usually). However, as >CFQueryParam did not help the problem, try the PreserveSingleQuotes(): > >SET > Drive = #PreserveSingleQuotes( FORM.drive )# > > > >..................... >Ben Nadel >Certified Advanced ColdFusion MX7 Developer >www.bennadel.com > >Need ColdFusion Help? >www.bennadel.com/ask-ben/ > >-----Original Message----- >From: Stephen Power [mailto:[EMAIL PROTECTED] >Sent: Monday, February 12, 2007 2:04 PM >To: CF-Newbie >Subject: Re: SQL UPDATE Statement error > >We might be getting somewhere now. After I removed the >AmountFull='#form.percentfull#' statement, nothing changed. However, >after I removed Usage='#form.usage#', the error detail in the <cfcatch> >tag changed to read: "Syntax error in string in query expression >'Drive='C:'." (C: is the name being passed in on the form via a hidden >input and is not changeable, and C: is the value in the database under >the Drive field as well). Is the single ' (quote) before Drive causing >an error? This quote is not listed anywhere in my code, but it is >showing up in that error message detail. >Tarvalon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2553 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
