Edward Roberts wrote: > 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 >   >
This query looks valid...except for that "YEAR" column. "YEAR" is generally a reserved function name, and isn't a good name for a database column. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2788 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
