okay....I had adapted some code from another project that used a parent_id of 0 instead of nulls. If you could change yours form nulls to zeros, then change the last line to <cfset list_generate(0)/>, that would work.
Unfortunately, I'm writing this blindly since I don't have the datasource :) On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > I get an error > > Query Of Queries syntax error. > Encountered "parent_id = NULL. Incorrect conditional expression, Expected > one of [like|null|between|in|comparison] condition, > > > > ----- Original Message ----- > From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Thursday, September 28, 2006 10:23 AM > Subject: Re: Arghhhh!! > > > > 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:254661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
