Recursive query in VBS / asp / access

Do a self-join on the table in your recordset; no function necessary.

"Tag2007" <webforumsuser@macromedia.com> wrote in message
news:eaq1m7$juo$1@forums.macromedia.com...
> Hi All,
> I hope someone can advise me here...
>
> I have a page that pulls a record from my database and this is working
> fine.
>
> But there is info in this recordset that is numerical and relates to
> another
> field in the recordset...
>
> I need to grab this ID number and search the recordset or database and
> pull a
> field from the recordset/database and place it on my detail page along
> with the
> other data.
>
> I need to do this around 30 times to build up some info on my page.
>
> I have made a function that will do this for me but Im a little stuck on
> how
> to carry it off on an asp page as I need to place the returned values at
> certain places on the page and dont know if I should be setting Session
> Vars to
> hold my values that the recursicve query will return or do I do this
> another
> way?
>
> Any thoughts or ideas on how i can do this would be appreciated.
>
> I have also put my recursive function into and external include page to
> keep
> my main page less cluttered is this OK to do?
>
> Many thanks
> Tag
>
>
>