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:2536 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
