Ask a Question related to Coldfusion Database Access, Design and Development.
-
WuFei #1
Possible to use cfprocresult from a previous cfstoredproc in a cfquery?
I'm new to ColdFusion and I want to know if it is possible to use the
cfprocresult value from a previous cfstoredproc in a cfquery or
cfselect or whatever.
For example:
<cfstoredproc datasource="a" procedure="b">
[...]
<cfprocresult name="myresult">
</cfstoredproc>
<cfquery [...]>
select * from myresult order by field1
</cfquery>
If it is possible, what would be the parameters to use in cfquery,
cfselect or whatever.
Thanks in advance.
WuFei Guest
-
Help with cfstoredproc
OK I have huge problem with my cfstored proc I have stored procedure which retrieve lost password when you provide email. Stored procedure is... -
cfprocresult doesn't work
Firstly, let me say I am fully aware of the issue regarding using cfprocresult in MX (in my case 6.1). It seems that has tripped up a lot of people.... -
cfquery vs cfstoredproc
In my experience, the SPs execute a little faster then the queries. you can use to test on your own. <CFSET start=GetTickCount()> ... some CFML code... -
cfquery vs cfstoredproc
Is there a difference in speed between using cfquery to call a stored procedure (MSSQL 2k) and using cfstoredproc? I understand the data integrity... -
cfstoredproc
Any chance you're interested in emailing with me about CF coding related to a Informix db back-end? Please email me off-list at...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
