> I am having a problem output nested infomation. I can't seem to
> get more than 1 query (ie record stream) to output at a time.
> Basically I have a database where in one table there is a 'parent'
> record, and the other table has 'children' records, of which there
> could be many.
>
> Now I want to output some information about the parent, and then
> list the children, and do this for many records in the db. If I
> use the cfoutput query= name for the parent record, I have to
> close that before I can output the child records. Even using cfloop
> to display the child records doesn't seem to let me nest inside the
> outer cfoutput. Since the logic in my program does a lot of processing
> and has many if statements within the outer cfoutput, openning and
> closing and openning and closing cfoutput is really awkward. Isn't
> there any reasonable way to nest there cfoutput (except using group
> which doesn't really apply)?
Why doesn't the GROUP attribute apply? It sounds to me that what you're
trying to do could be best accomplished with a single query which joins the
parent and child table, orders by the parent field, in conjunction with a
nested CFOUTPUT using the GROUP attribute.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
