How about when calling the SP from a cfquery and passing parameters? Do
they still have to be in the same order in the cfquery as in the sp?
Like this:
<cfquery name="xyz" datasource="xyz">
exec MyStoredProc '#VariableOne#', '#VariableTwo#'
</cfquery>
Issac Rosa
-----Original Message-----
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:39 AM
To: CF-Talk
Subject: Re: Stored Procedure Variables from CF
THANKYOU for raising this issue... just playing with cfstoredproc and
couldn't understand why I was getting strange results
now I know why.
(this is definitely something which is an exception to usual CF
behaviour)
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
