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
>Wait, If you are doing this inside the CFCatch statement, that means >that the SELECT * statement was throwing an error? > > >..................... >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:48 PM >To: CF-Newbie >Subject: Re: SQL UPDATE Statement error > >When I try to dump the update variable inside the cfcatch statement, I >get the error message "Variable UPDATE is undefined." I checked the >permissions set up on the ColdFusion admin page just to be sure that >UPDATE statements are permitted, and they are, so that shouldn't be the >source of the problem. >Should a (<cfdump var="#update#" />) inside the <cfcatch >type="database"> tag be displaying anything? I thought if the query was >run in the <cftry> portion then the variable will no longer exist in the ><cfcatch> portion, but I don't know for sure. > >Thanks, >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:2535 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
