A quick and dirty method would be to wrap a cfoutput block inside of a cfloop
(type=query) block, instead of nested cfoutput's.
---
Billy Cravens
[EMAIL PROTECTED]
Ruthie Siegel wrote:
> From: "Ruthie Siegel" <[EMAIL PROTECTED]>
> To: <cf-talk@houseoffusion>
> Sent: Wednesday, June 21, 2000 4:29 PM
> Subject: Re: Nesting Output
>
> > there is not a on to one relationship between parent and child and there
> are
> > actually a couple of different child tables which need to be accessed -
> > based on some value in the parent table. So it's rather complicated and
> it
> > can't be done with the group attribute.
> >
> > Any other ideas??
>
> > ----- Original Message -----
> > From: "Dave Watts" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 21, 2000 4:20 PM
> > Subject: RE: Nesting Output
> >
> >
> > > > 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.
--
-----
Billy Cravens
[EMAIL PROTECTED]
------------------------------------------------------------------------------
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.
