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
>Ahh, the UPDATE statement will not return variables because it doesn't >perform any SELECT statement. That makes sense. > >What happens if now you go back to the update statement put only update >ONE field, not two.... Let's try to narrow this sucker down. > > >..................... >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 1:56 PM >To: CF-Newbie >Subject: Re: SQL UPDATE Statement error > >No, the SELECT * statement never threw an error. At first, nothing >displayed (the select statement worked, and I wasn't outputting >anything). Then, I outputted the variables inside the <cftry> portion, >and they all showed up on the screen. The SELECT statement works fine, >it's the UPDATE statement that the (<cfdump var="#update#" />) code >fails with, as that dump statement is located in the <cfcatch> tag. >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:2537 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
