Stored Procedure Not Working

2008-07-01 Thread Phillip Vector
I have a MS SQL database and I have a stored procedure I'm trying to call with the following code.. cfset FutureTime=DateAdd('', 3, Now()) cfoutput#futureTime#/cfoutput cfstoredproc procedure=GetDate dataSource=#datasource# cfprocparam type=IN CFSQLType=CF_SQL_DATE value=#FutureTime#

RE: Stored Procedure Not Working

2008-07-01 Thread Brad Wood
: Stored Procedure Not Working I have a MS SQL database and I have a stored procedure I'm trying to call with the following code.. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free

Re: Stored Procedure Not Working

2008-07-01 Thread Phillip Vector
On Tue, Jul 1, 2008 at 2:55 PM, Brad Wood [EMAIL PROTECTED] wrote: Hmm, right off the bat, I don't think the browser would make any difference unless you have ColdFusion code that behaves differently depending on the browser. Perhaps something is being cached. I cleared out the cache and

RE: Stored Procedure Not Working

2008-07-01 Thread Brad Wood
Named parameters didn't work in CF7. There was a Hotfix that made them work but I don't think it was ever part of the 7.0.1 or 7.0.2 release. I don't know if it made it into CF 8 or not. Chances are ColdFusion was defaulting to the usual practice of going off the order of the proc param tags.

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

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:

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

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! Do you do much w

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread David Cummins
000 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 gettin

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";

Re: Stored Procedure Not Working, Help?

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