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.
