Ben, Your syntax has commas in it that are not syntactically correct.... The error is telling you this - incorrect syntax near ","
Note this line in your insert code: njuice', '', 1903, 189, 123.45, , , 'clamprack See the three commas in a row? There should be something there... An empty string.. .a zero... The word "null" .... Something.. -----Original Message----- From: Ben Conner [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 12:35 PM To: CF-Talk Subject: DB Insert error in SQL Server Hi, I ported an application from Access to MS SQL Server and am getting an error when inserting a test record into a table: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 21: Incorrect syntax near ','. The error occurred in D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 121 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 78 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 77 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 44 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 1 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\index.cfm: line 143 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 121 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 78 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 77 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 44 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\ProductForm.cfm: line 1 Called from D:\sites\adrenalinebikes.com\htdocs\Admin\index.cfm: line 143 119 : #ImageCR.width#, 120 : #ImageCR.height#, 121 : #CurrentLevel#) 122 : </cfquery> 123 : <cfabort> SQL INSERT INTO Products(ProductName, Sku, ShortDesc, LongDesc, CategoryID, ManufacturerID, UnitCost, Weight, ShipBase, Image, ImgWidth, ImgHeight, ProductLevel) VALUES ('benjuice', '', 'benjuice', '', 1903, 189, 123.45, , , 'clamprack1.jpg', 329, 600, 2) DATASOURCE adren VENDORERRORCODE 170 The last 3 fields (imgwidth, imgheight, and productlevel) are all Int 4 byte fields, nulls allowed. Any idea what the issue might be? Thanks! --Ben +-------------------------------------------+ + Ben Conner [EMAIL PROTECTED] + + Web World, Inc. 888-206-6486 + + PO Box 1122 480-704-2000 + + Queen Creek, AZ 85242 + +-------------------------------------------+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
