Hi all,

Here's a bit of a challenge.  I have a single table storing category 
information similar to any search engine.  The table structure looks
like this
ID      Name            ParentID        Level
1       Computers       0               1
2       Laptop          1               2
3       Desktop 1               2

Since I have to display this information I must join the table back to
itself.  All joining has gone fine :)  My problem is in the display of the
information to the users.  I want to display the Parent category
and then only 3 children from each category.  Sounds easy but
I'm not sure if I can do this in sql or not.  If sql could accomplish
this then super, if not then it's a good CF challenge.

Any ideas?


-------------------------------------------------
Jason Dowdell
IM-AES Web Developer
321.799.6845
[EMAIL PROTECTED] 
-------------------------------------------------


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Reply via email to