I thought of that, but I looked at some old code I had and you don't have to do
that...
David Cummins
"Heather R. Moll" wrote:
>
> 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.
------------------------------------------------------------------------------
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.
