Can you pass along the error message you are getting in the CF Error Dump?
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: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 >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:2525 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
