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