parent_id IS NULL Nic
Doug Brown 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:254688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
