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#
: 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
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
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.
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
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'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
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
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
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";
: 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
11 matches
Mail list logo