Interesting. That did it! One more subtle difference between Access and SQL Server. Thanks much!!
--Ben Sonny Savage wrote: >I've never used Access, but yeah, the specification of NULL is required. ><cfif len(form.field) GT 0>#form.field#<cfelse>NULL</cfif> > >On Feb 12, 2008 2:57 PM, Ben Conner <[EMAIL PROTECTED]> wrote: > > > >>Oh. So for null numeric fields, one has to put in "null"? Why wouldn't >>this have failed under Access? Or is this part of the 'I'm a REAL >>database' that SQL Server is enforcing? ;-) >> >>--Ben >> >>Mark Kruger wrote: >> >> >> >>>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:298816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
