Want recursive SQL query function to generate breadcrumb navigation to top level

[Ken Fine]

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

[Alexandro Colorado]

On Tue, 29 Mar 2005 16:53:07 -0800, Ken Fine <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 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
>
>

We have an extension called MX Breadcrumbs which might help you solve your
issues, plus is free :D
[url]http://www.interaktonline.com/Products/Free-Products/MXBreadcrumbs/Overview/[/url]


--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312