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