Re: nested hierarchical query question

2011-03-14 Thread LRS Scout
http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm This has been useful. On Mon, Mar 14, 2011 at 7:20 PM, LRS Scout wrote: > Yeah man a recursive function is probably going to be the answer I've seen > it done with directory structures I'm just having a brain cramp o

Re: nested hierarchical query question

2011-03-14 Thread LRS Scout
Yeah man a recursive function is probably going to be the answer I've seen it done with directory structures I'm just having a brain cramp on how to make it work here. On Mon, Mar 14, 2011 at 7:17 PM, Judah McAuley wrote: > > Are you looking for help on the db part or constructing the UI displa

Re: nested hierarchical query question

2011-03-14 Thread Judah McAuley
Are you looking for help on the db part or constructing the UI display or both? When it comes to the DB part, I listen to Joe Celko. That dude knows way more about databases and SQL than any person ought to. Here's an article of his on messing with hierarchical data in SQL: http://onlamp.com/pub/

nested hierarchical query question

2011-03-14 Thread LRS Scout
I have a table departments with the fields departmentID, parentDepartmentID, departmentName. I'm trying to build a nested ul li structure out of this. Currently this can be nested n deep. I'm not sure how best to even approach this. SQL Server 2008. god this sounds dumb even to me.