>- see footer for list info -< "you have too few columns in the columns clause and too many values in the values clause...." ;P
Are you putting stuff in the "numeric" fields that are comma delimited lists??? That would be my first point of call on this one. Cheers, Tom ----- Original Message ----- From: Paul Swingewood To: [EMAIL PROTECTED] Sent: Friday, November 19, 2004 10:57 AM Subject: [CF-Dev] INSERT .... >- see footer for list info -< Can anyone help with this one please ...? I keep getting an error message that says ... [Macromedia][SQLServer JDBC Driver][SQLServer]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. <CFTRANSACTION> <CFSET Now = #LSDateFormat(now(), "dd mmm yyyy")#> <cfset TotalCost = #lscurrencyFormat(getpackage.packagecost*form.Quantity)#> <CFQUERY Name="CreateOrder" datasource="#application.dataDSN#"> INSERT INTO tblOrderDetails ( OrderDate, Dfes, ContactName, FocusArea, PackageIDFK, Quantity, TotalCost ) VALUES ( '#now#', '#session.dfes#', '#form.contactName#', '#form.focusarea#', #form.packageID#, #form.quantity#, #TotalCost# ) </cfquery> </cftransaction> Regards - Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
