<cfstoredproc procedure="procedureName" datasource="xyz">
<cfprocparam type="IN" blah blah>
<cfprocresult name="myQueryName">
</cfstoredproc>
then <cfloop query="myQueryName">...
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:40 AM
To: CF-Talk
Subject: RE: CF5 and Stored Procedures
> I have a stored procedure that executes a somewhat complex
> query on a SQL 2000 database and returns a result set. How
> do I access that result set using CF? I've had lots of
> trouble getting the <cfstoredproc> and <cfprocparam> tags to
> work ( don't know what I'm doing wrong! > so I've been
> successfully using <cfquery> to execute stored procedures
> which don't return a result set, but now I have one that does
> and I'm stuck. Help!
If your SQL Server stored procedure returns a single resultset, you should
be able to just call it within CFQUERY without any trouble. You might want
to post the code for your stored procedure and your corresponding CFML
code.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
