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