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.
