It is for a tree/hierarchy possibily nested set or adjacency model.
example output:
mens/
mens/shirts
mens/shirts/tshirts
womens/
womens/shirts/
womens/shirts/tanktops
OR ID Values
1/
1/3
1/3/5
2/
2/4
2/4/6
I need the table structure, select/insert/update/delete and a query to take the bottom value (ie tanktops) and find the path back to the top /womens/shirts/tanktops/).
I am looking for someone who can provide a $ amount for this that can write this for MSSQL / MySQL and hopefully Access.
My thought is there is already queries for this and if you have them and would like to share for a few $$, I would greatly appreciate it.
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
