> 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]
