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 >What happens when you run this query: > ><cfquery name="update" datasource="Web2" dbtype="oledb"> > SELECT * > FROM DiskUsage > WHERE Drive='#form.drive#' ></cfquery> > >Does that work? > > >..................... >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:29 PM >To: CF-Newbie >Subject: Re: SQL UPDATE Statement error > >Bob: The #usage#, #percentfull#, and #drive# variables are all form >variables being passed in. > >Mr. Nadel: Adding the <cfparam> tags didn't fix the issue. It did >produce a slightly different SQL statement, however, in that the SQL >statement itself now has values of <param1>, <param2>, and <param3> for >the values for #percentfull#, #usage#, and #drive#. > >Mr. Weidler: The error message I am receiving is: "Error Executing >Database Query." >The error detail is: "Syntax error in UPDATE statement." >I found these using a <cftry> and <cfcatch> setup and then dumping ><cfdump var="#cfcatch.message#"> <cfdump var="#cfcatch.detail#"> If >there is another way to dump out error messages using the <cferror> >tag, I would love to know how, especially if it produces better results >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:2532 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
