Recursive query in VBS / asp / access

[Tag2007]

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

[Newsgroup_User]

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
>
>
>

[Tag2007]

Hi Lionstone,

I do not understand this table join in my recordset, can you explain this or show me a tutotial to explain it please.
Thanks
Tag

[Newsgroup_User]

www.sqlcourse.com
www.sqlcourse2.com

"Tag2007" <webforumsuser@macromedia.com> wrote in message
news:ear0u4$1dp$1@forums.macromedia.com...
> Hi Lionstone,
>
> I do not understand this table join in my recordset, can you explain this
> or show me a tutotial to explain it please.
> Thanks
> Tag

[Tag2007]

Thank you I will have a read through it.

I have it working with querys built up in my database but they are very complicated and want to simplify things.

Thanks again
Tag