Scott,
If you are not going the OO way, where the records are setup in init() and
each one has a get method for example, you can just use a structure -
each query would be a key of the scructure as in str.qry1, str.qry2 etc.
-Mark
-Original Message-
From: Scott Stewart [mailto:[EMAIL
There may be a better way, but you could stick the three recordsets into an
array, think that would work.
cfset resultQueries = ArrayNew(2)
cfset resultQueries[1].queryHolder = query1 /
cfset resultQueries[2].queryHolder = query2 /
cfset resultQueries[3].queryHolder = query3 /
cfreturn
On Tuesday 29 Jul 2008, Paul Giesenhagen wrote:
cfset resultQueries = ArrayNew(2)
cfset resultQueries = ArrayNew(1)
?
--
Tom Chiverton
This email is sent for and on behalf of Halliwells LLP.
Halliwells LLP is a limited liability
Oops ... that'd be correct...
On Tuesday 29 Jul 2008, Paul Giesenhagen wrote:
cfset resultQueries = ArrayNew(2)
cfset resultQueries = ArrayNew(1)
?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
Hi Scott,
I'd probably go Mark's route and make each a method of the cfc:
cfcomponent
cffunction name=getPeople returntype=query
!--- query one ---
/cffunction
cffunction name=getPlaces returntype=query
!--- query two---
/cffunction
cffunction name=getCompanies
To: CF-Talk
Subject: Re: Returning multiple recordsets in a single component
Hi Scott,
I'd probably go Mark's route and make each a method of the cfc:
cfcomponent
cffunction name=getPeople returntype=query
!--- query one ---
/cffunction
cffunction name=getPlaces returntype=query
if the queries aren't related, then most likely they shouldn't be grouped
together logically :)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
-Original Message-
From: Yuliang Ruan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 10:12 AM
To: CF-Talk
Subject: Re: Returning multiple recordsets in a single component
if the queries aren't related, then most likely they shouldn't be grouped
together logically
8 matches
Mail list logo
