Anyway in case you're interested, here's the code:
<cfquery datasource="TBL_Appl_Inv" name="AppQuery">
EXEC up_Appl_Summary
<cfswitch _expression_="#FORM.cboSearch#">
<cfcase value="all"></cfcase>
<cfcase value="person">@Person_Nm = #FORM.cboSearch#</cfcase>
<cfcase value="org">@Org_Cd = #FORM.cboSearch#</cfcase>
<cfcase value="sName">@Appl_Short_Nm = #FORM.cboSearch#</cfcase>
<cfcase value="function">@Business_Function_Nm = #FORM.cboSearch#</cfcase>
</cfswitch>
<cfif isDefined("FORM.chkRetired")>@Include_RetiredCancelled = 'Y'</cfif>
</cfquery>
>We have always been able to make it work with <CFPROCRESULT
>
><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]
