I have the following code:
<cfstoredproc datasource="#WME.DSN#" procedure="qGetStates" returncode="Yes">
<cfprocparam type="In" dbvarname="@State_ID" value="#license_state_ID#"
cfsqltype="CF_SQL_INTEGER">
<cfprocparam type="In" dbvarname="@State_ID" value="#state_ID#"
cfsqltype="CF_SQL_INTEGER">
<cfprocresult name="qGetStates">
</cfstoredproc>
I have the SP on the SQl Server and it works. However, when I run the page, I receive
the following error message:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure qGetStates has no parameters
and arguments were supplied.
SQL = "qGetStates"
Data Source = "WME"
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (7:1) to (7:77).
I have debugging on and the form variables are being passed. I have also prefixed the
values with Form. and it still does not work.
Thanks,
-bs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
