I think that FULL is a reserved word in SQL. Must put [] around it:
<cfquery name="update" datasource="Web2" dbtype="oledb">
UPDATE
DiskUsage
SET
[Full]='#form.percentfull#',
Usage='#usage#'
WHERE
Drive='#form.drive#'
</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:40 PM
To: CF-Newbie
Subject: SQL UPDATE Statement error
Hey everyone,
I've been working with this (extremely basic) UPDATE statement for quite
some time now, and I can't seem to find the problem. Here's the code:
<cfquery name="update" datasource="Web2" dbtype="oledb">
UPDATE DiskUsage
SET Full='#form.percentfull#', Usage='#usage#'
WHERE Drive='#form.drive#'
</cfquery>
I've verified that the spelling of my datasource, table name, field
names and form names are all correct. Whenever I attempt to run the
query, I get the "Syntax error in UPDATE statement" error message, with
the first line highlighted. I've tried running the query directly in
Access, and everything works just fine. As far as I can tell, I am not
using any reserved words, either. In the database, the Full, Usage, and
Drive fields are all set to a Data Type of text with a Field Size of 50.
If you could give me some help, I would greatly appreciate it.
Thanks,
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:2520
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
