Let's see the SP.
----- Original Message -----
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 4:24 PM
Subject: Stored Procedure Question
> 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
