I've used stored procedures a little, and that looks pretty much OK. The
"variable" attribute isn't needed for input parameters, though. The DBVarName
should definitely help.
All I can suggest is the obvious - you're passing in the wrong variable name or
type, or calling the wrong stored procedure. Have you tried calling it from
query analyzer?
David Cummins
Avi Flax wrote:
>
> Sending this question in for a friend. Thanks for any replies!
>
> Do you do much with stored procedures in Cold Fusion? It's one thing I do
> little with, and I'm stuck. I keep getting an error from the SP saying it
> isn't getting @CustomerID, which it expects. Here's the code I'm using:
>
> <CFSTOREDPROC PROCEDURE="InsertOrder" DATASOURCE="#DSN#">
> <CFPROCPARAM
> TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" VARIABLE="CustomerID"
> DBVARNAME="CustomerID" VALUE="#CustomerID#" NULL="No">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="NetAmount" VALUE="#NetAmount#">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="Tax" VALUE="#Tax#">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="TotalAmount" VALUE="#TotalAmount#">
>
> I just tried adding the DBVARNAME parameter but that didn't help.
>
> Help? :)
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.