the easier way is to have a table structure like this category_id, categoryName, treeID
where category_id is your integer pk, name is obvious, treeID is 00001 0000100001 0000100002 00002 0000200001 etc like that. just order by treeID and you get everything in one query.. get a section like treeid LIKE '00001%' ken -----Original Message----- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 2:10 PM To: CF-Talk Subject: RE: Recursive queries There is an example in the SQL Server book on-line on how to do this. I do not remember where, but it does not use recursion. Recursion is very cool (I happen to love it) but is not terribly efficient, probably why LISP never caught on. Justin > -----Original Message----- > From: chris.alvarado [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 11:37 AM > To: CF-Talk > Subject: Recursive queries > > Still trying to decide how I like to perform some type of recursive > query wth the following Table structure; > > ID NAME PARENT_ID > > If the current record IS the parent then the Parent ID is 0 > > Otherwise the child has the ID of the parent as it's Parent ID. > > > Anyone have any good references on recursive queries to handle this? A > way to spider down through the parents and children basically. > > Ive done this before using Stored Procs and temp tables, but there has > to be an easier way. > > Any suggestions? > > > -chris.alvarado > [ application developer ] > 4 Guys Interactive, Inc. > http://www.4guys.com > > -- I can picture in my mind a world without war, a world without hate. > And I can picture us attacking that world, because they'd never expect > it. -- Jack Handy > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
