Column name or number of supplied values does not match table definition.

Question

i had a stored proc for which i made changes and added 2 new form fields to a stored proc and then ran it successfully now when i revoke the stored proc and run , it runs successfully but in the coldfusion it gives the error

[Macromedia][SQLServer JDBC Driver][SQLServer]Insert Error: Column name or number of supplied values does not match table definition. 


90 :     <cfprocparam  type="in" cfsqltype="CF_SQL_INTEGER" dbvarname="@reportMonth"  value="#xxMDB#">
91 :     <cfprocparam  type="in" cfsqltype="CF_SQL_INTEGER" dbvarname="@orderBy"     value="#xxOBDB#">
92 :     **<cfprocresult name="xxResult">**
93 : </cfstoredproc>

Answer 1

Since ColdFusion MX:

Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion uses JDBC 2.2 and does not support named parameters.

http://www.cfquickdocs.com/cf8/#cfprocparam