>- see footer for list info -< the ones with quotes around them wont matter... so only the quoteless ones will be an issue! ----- Original Message ----- From: Kerry To: Coldfusion Development Sent: Friday, November 19, 2004 11:11 AM Subject: RE: [CF-Dev] INSERT ....
>- see footer for list info -< my guess, theres gonna be a "," in one of these fields... '#session.dfes#', '#form.contactName#', '#form.focusarea#', #form.packageID#, #form.quantity#, #TotalCost# -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Swingewood Sent: 19 November 2004 10:57 To: [EMAIL PROTECTED] 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 -< _______________________________________________ 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 -<
