> >Note that when you use the GROUP attribute, you can nest CFOUTPUTs.
>
> How would I do this if it is a standard parent/child table
> with the fields cat_id, catname, parent_cat_id, parent_catname?
> I think I now how the query would work but that is about it.
I think you could do it by using a self-join and aliases for columns drawn
from one side of the join.
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.
