Is the customer id always going to get passed into the proc?
Maybe in the procedure it should be = NULL???
Just tossing out ideas
----- Original Message -----
From: David Cummins <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 22, 2000 6:29 PM
Subject: Re: Stored Procedure Not Working, Help?
> 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/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.
> --------------------------------------------------------------------------
----
> 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.