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
>Here is a link to all Access 2002 and 2003 Reserved Words.
>
>http://support.microsoft.com/kb/286335
>
>
>Chuck Weidler
>Lockheed Martin Information Technology
>3108 Lord Baltimore Drive
>Baltimore, MD 21244
>Voice: (443) 348-2169
>Fax: (443) 348-2233
>Email: [EMAIL PROTECTED]
>
>-----Original Message-----
>From: Stephen Power [mailto:[EMAIL PROTECTED]
>Sent: Monday, February 12, 2007 12:46 PM
>To: CF-Newbie
>Subject: Re: SQL UPDATE Statement error
>
>I did miss the fact that Full is a reserved word, but unfortunately that
>did not fix the problem. The highlighted line jumped down to WHERE
>Drive='#form.drive#', however.
>Thanks for the quick response and the help, any other ideas?
>Tarvalon
>
>code:
>
>>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:2524
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
