Put CFQueryParams for all the variables:
<cfquery name="update" datasource="Web2" dbtype="oledb">
UPDATE
DiskUsage
SET
AmountFull= <cfqueryparam value="#form.percentfull#"
cfsqltype="CF_SQL_VARCHAR" />,
Usage=<cfqueryparam value="#usage#" cfsqltype="CF_SQL_VARCHAR"
/>
WHERE
Drive=<cfqueryparam value="#form.drive#"
cfsqltype="CF_SQL_VARCHAR" />
</cfquery>
......................
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 12:56 PM
To: CF-Newbie
Subject: Re: SQL UPDATE Statement error
Thank you, that will be really helpful in the future. I've changed
around the Field Names and the code so I am no longer using any reserved
words, but I'm still getting the same error. Here's the current code:
<cfquery name="update" datasource="Web2" dbtype="oledb">
UPDATE DiskUsage
SET AmountFull='#form.percentfull#', Usage='#usage#'
WHERE Drive='#form.drive#'
</cfquery>
Any ideas?
Thanks again,
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:2526
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
