I thought this returned a resultset: <cfprocresult name="Cases" resultset="1">
Please advise. On Thu, 3 Feb 2005 16:09:26 -0500, Dave Carabetta <[EMAIL PROTECTED]> wrote: > On Thu, 3 Feb 2005 15:53:11 -0500, Greg Luce <[EMAIL PROTECTED]> wrote: > > I'm cleaning up some old code, can anyone say why this returns records: > > > > <cfquery datasource="#SESSION.Datasource#" name="Cases"> > > execute SearchCases '#Search#', '#ReferralType#', '#CaseType#', > > '#NumberType#' > > </cfquery> > > > > And this doesn't: > > > > <cfstoredproc procedure="SearchCases" datasource="#session.datasource#"> > > <cfprocresult name="Cases" resultset="1"> > > <cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="#Search#"> > > <cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="#ReferralType#"> > > <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" value="#CaseType#"> > > <cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="#NumberType#"> > > </cfstoredproc> > > > > Because there is no OUT parameter or cfprocresult tag to handle the results? > > Regards, > Dave. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54