CF reports the error as being in line 54 as that is the last line of the query. The error could in fact be anywhere within the query. Post the entire query. I suspect you are missing a comma, have single quotes in the data, or some other such difficulty.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Edward Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 8:25 PM To: SQL Subject: Error Executing Database Query Syntax error in UPDATE statement The error occurred in D:\CFusionMX7\wwwroot\ant_lo_auto\update_results.cfm: line 54 52 : NULL 53 : </cfif> 54 : WHERE ID = #FORM.ID# 55 : </cfquery> 56 : <cflocation url="search_critera.cfm"> This is were the problem is in line 54, I can pull all the infomation fromfrom the form page but when I click the update button I get the following error. This is pulling the primary key but not updating the database. Hereis what the form places in: UPDATE vehicle_list SET MAKE= 'OLDSMOBILE ' , MODEL= 'FE3 C REGENCY 98' , VIN_NUM= '1G3CW54C1K4308030' , YEAR= 1989 , COLOR= 'BLUE' , DOWN_PAYMENT= 500.0000 , STICKER_PRICE= 900.0000 , SALE_PRICE= NULL WHERE ID = 13 DATASOURCE vehicle_list VENDORERRORCODE 3092 SQLSTATE   Thanks in advance for any help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2787 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
