I use stored Procs as much as possible (as you should - much quicker). I
would certainly suggest doing what Heather suggested by putting the @ before
the dbVarName. also remeber that it does matter what order you declare your
params in CF. They must be declared in the same order as they appear in the
SP.
-----Original Message-----
From: Avi Flax [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 20:16
To: [EMAIL PROTECTED]
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.
