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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2786 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
