try dbvarname="@CustomerID"
----- Original Message -----
From: Avi Flax <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 22, 2000 2:15 PM
Subject: Stored Procedure Not Working, Help?
> 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/[email protected]/
> 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/[email protected]/
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.
