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 >And are the columns you are trying to update showing up in the results >(<cfdump var="#update#" />)? > >If they are, they maybe it's an update issue? I don't know much about >permissions, but maybe it doesn't have permissions to update??? > > >..................... >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:38 PM >To: CF-Newbie >Subject: Re: SQL UPDATE Statement error > >No problems with that query at all. >Tarvalon > > > >>than the <cftry>, <cfcatch> format I currently use. >> >>Thanks for all the help everyone, I really appreciate it. >> >>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:2534 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
