oops, that last line should be <cfset list_generate(parentID="")/>
On 9/28/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > <cffunction name="generate_list" output="true" > > <cfargument name="parentID" required="true"/> > > <cfset var list_items = "" /> > > <cfquery name="list_items" dbtype="query"> > SELECT catID,category,parent_id > FROM categories > WHERE parent_id = <cfqueryparam value="#parentid#" > null="#(parentID eq "")/> > </cfquery> > > <cfif list_items.recordcount gt 0> > <cfloop query="list_items"> > <cfif list_items.currentrow eq 1><ul></cfif> > <cfoutput><li>#category#</cfoutput> > <cfset generate_list(sID)/></li> > - Hide quoted text - > <cfif list_items.currentrow eq > list_items.recordcount></ul></cfif> > </cfloop> > > </cfif> > > </cffunction> > > <cfset generate_list(0)/> > > > On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > See, there I go again not making my self clear. The table actually has more > > than just makes and models of cars. > > It has antiques, autos, furniture, blah blah. each parent category has it's > > child category and each child has it's own child. As an example, Antiques > > would have a child of asian antiques and it would have a child of all the > > different asian antiques you could think of. I hope this makes more sense. > > Anyhow the first group of childs I can refer back to their parent, but the > > second group of childs are referenced back to the child of the parent and > > not the parent directly. > > > > > > > > > > Doug > > > > > > > > ----- Original Message ----- > > From: "Jim Wright" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[email protected]> > > Sent: Thursday, September 28, 2006 9:43 AM > > Subject: Re: Arghhhh!! > > > > > > > Doug Brown wrote: > > > > Hey Jim...I have one more quick question for you. > > > > > > > > As I stated before I have just the one table to display the makes and > > models > > > > for the menu, and I am kinda dumbfounded as to how to display all the > > makes > > > > on one page with their corresponding models beneath them. Can this be > > > > accomplished with one table? > > > > > > > > IE: > > > > > > > > cat_id > > > > category > > > > parent_id > > > > > > > > Right now the data looks like so > > > > > > > > cat_id category parent_id > > > > 1 chevy null > > > > 2 ford null > > > > 3 Camaro 1 > > > > 4 Escort 2 > > > > > > Something like... > > > > > > SELECT a.category AS make, b.category AS model > > > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > > > WHERE a.parent_id IS NULL > > > ORDER BY a.category,b.category > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
