You could run a query that was ordered by the parent ID.
Then you could do a grouped cfoutput/cfloop.
While in that loop you could set the variables.queryObject using query of queries.
That would solve your problem of needing individual queries...
Good Luck,
Chris Phillips
On 9/20/06, Micah Parker <
[EMAIL PROTECTED]> wrote:
Ive got a very deep hierarchy of tables and im running into performance
issues when having to retrieve the entire hierarchy or Records. The
performace issue comes due to reactor having to run a query for each
Record. So, i built a function in the highest Record of the hierarchy to
query all of the tables and set the hierarchy of Records manually by
calling each of the individual set[column_name] functions. This way one
query sets the entire hierarchy of Records. It works great until i get
to the one-to-many relationships. I cant seem setup an iterator so that
it never has to run a query. It seems that iterators *must* run the
variables.queryObject in order to properly initialize itself.
Is this true? Is there a better way to do what im trying to do (set an
entire hierarchy of records w/ 1 query)?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Chris Phillips
www.dealerpeak.com
Senior Application Developer
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
