Home > Archive > ASP > March 2005 > Want recursive SQL query function to generate breadcrumb navigation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Want recursive SQL query function to generate breadcrumb navigation
|
|
|
| I'd want to make a custom class that will generate breadcrumb navigation for
my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've
structured my database with hierarchical parent/child relationships. Can
someone help me set up the code structure?
I'm using ASP VBScript, and I have a table structure similar to the
following:
NavItems
----------
NavitemID (PK)
Nav_ParentID
Nav_Name
The top level record in the entire table is "1", but it would be nice if I
could parameterize the function so that I could specify the ID of the
current page and the ID of the topmost ID I want to trace to, e.g.
GetTrailOfBreadcrumbs(CurrentNavitemID, TopmostNavitemID)
The least expensive approach from the standpoint of the database would be
something that used something besides ADO recordsets to grab the data. If
someone has some code lying around or can offer some guidance, I'd sure
appreciate it.
Thanks.
-KF
| |
| Bob Barrows [MVP] 2005-03-30, 8:55 am |
| kenfine@u.washington.edu wrote:
> I'd want to make a custom class that will generate breadcrumb
> navigation for my site via a recursive query, e.g. Home > Page1 >
> Subpage 1. I've structured my database
What database? It's relevant.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
|
| I use SQL Server 2000, and I have access to stored procedures.
Whatever's returned by the DB needs to have more information than just the
text label, since I'm also going to want to be generating HTML links from
this. My database table includes a "link" field.
Thanks again, Bob.
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:umeLgISNFHA.2356@TK2MSFTNGP14.phx.gbl...
> kenfine@u.washington.edu wrote:
>
> What database? It's relevant.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
|
|
|
|
|