>- see footer for list info -< Lower down in the error message there should be the full SQL statement that the driver has passed to the DBMS. What does that say?
btw <cfqueryparam> is always a good idea. Nick ----- Original Message ----- From: "Paul Swingewood" <[EMAIL PROTECTED]> 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 -<
