|
Hier Menus From DataBase
|
Email
|
| Submitted on: |
3/18/2001 2:36:30 PM |
| By: |
Loren Erickson
|
| Level: |
Advanced |
| User Rating: |
By 23 Users |
| Compatibility: |
ASP (Active Server Pages), HTML |
| Views: |
35097 |
|
(About the author) |
|
|
|
I have always loved the HierMenus found at Web Reference but I wanted to be able to grab information from a database to fill the nodes. Well one weekend and a case of Mountain Dew later, a totally reusable HierMenu from DB to Menu system.
There are some things you might notice:
1: Lack of More then useful comments.
Reason: you will have to be familiar enough with Java, DHTML and ASP to be able to really understand this.
2: GetRows() was used so if you are going to have lots of null Parent Nodes you might what to consider using MoveFirst, MoveNext Methods.
Reason: GetRows() is way faster.
3: HierMenus is a Product if you use it give credit were credit is due. I did not in any way create the HierMenus they were already made, all I did was find a way to provide Data from a DB to the menus.
Please Vote For Me!
|
 |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 1 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 3/18/2001 9:55:24 PM: Ericca
Now who well can you program your laundary, hehehe
Loves
Ericca
(If this comment was disrespectful, please report it.)
|
3/22/2001 12:16:33 AM: Sp-89
Nice!, Loren keep it up man,
lats
-Sp-89-
(If this comment was disrespectful, please report it.)
|
3/25/2001 2:57:57 AM: Entelarust
LOREN ROX!@
(If this comment was disrespectful, please report it.)
|
3/28/2001 1:08:40 PM: Wicked
Thanx I was suppose to write this,by this weekend instead I can implement it instead ..
cool
(If this comment was disrespectful, please report it.)
|
6/27/2001 6:02:49 PM: Jeff Michelson
Nice Code. One question, one comment. When Web Reference comes out with a new version, will your's have to be recoded to incorporate this new version? Second, a menu table structure I like is something like:
Table: Navigation
Fields:
NavigationKey number (the key)
NavText text (menu item text)
ParentKey number (parent navigationkey)
Ordinal number (order of item)
Where a few records would look like
NavigationKey NavText ParentKey Ordinal
1 Parent 0 1
2 Child1 1 1
3 Child2 2 3
4 Parent2 0 2
5 Child1 4 1
etc...
This allows you to have an unlimited number of parents and children in one simple table.
(If this comment was disrespectful, please report it.)
|
8/29/2001 9:57:53 AM: GJS Dad
Hi Loren,
Great Application - I'm working with the hier menu in the opposite direction. I want to build a database query system using hier menu by having each menu level selection concatenate its value resulting in a query string. All will be done in JavaScript. Have any ideas?
(If this comment was disrespectful, please report it.)
|
2/20/2002 7:24:38 PM: Jake
Hi Loren, I maybe asking sum't dim here, but can the db hier menu have more levels (easily)?
Thanks
Jake
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
