Stored Procedure Not Working, Help?

2000-08-22 Thread Avi Flax
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: I j

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread David Cummins
I've used stored procedures a little, and that looks pretty much OK. The "variable" attribute isn't needed for input parameters, though. The DBVarName should definitely help. All I can suggest is the obvious - you're passing in the wrong variable name or type, or calling the wrong stored procedur

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread Heather R. Moll
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! >

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread David Cummins
TECTED]> > 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 > > li

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread Nick Slay
This is a multi-part message in MIME format. --038B626790AA5924CFF82AAF Content-Type: multipart/alternative; boundary="8CB5F653C5DC7DE914071AAA" --8CB5F653C5DC7DE914071AAA Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread Heather R. Moll
ge - > > 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! > > >

RE: Stored Procedure Not Working, Help?

2000-08-23 Thread Andy Ewings
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