Hi,

I'm building a site in ASP with an Access DB. The site has news section. Which is populated from the DB.

If you click on the news story it take you to a detail page which displays the story.

What I'm wanting to do is have a move next/previous on the detail page.

I've tried putting one on the detail page but it doesn't work it just stayes on the pages it's on. To see what I mean click on the link www.reminiss.co.uk/urban/news/index.asp then select a news story.

The detail page has a request("id" on it, if I remove this form the SQL the next previous links work, but the link form the go to detail page takes you to the first story regardless of which one you click on.

Hope someone can help

regards
Wayne

Edited by - wayne1000 on 01 Jun 2004 15:09:06

1. you cant filter a recordset using sql and have navigation.
2. you filter the records outside of the sql on the detail page.

set up ya master and detail as normal, but on the detail page set it to "no" filter, so it grabs all the records. Upto now it will only show the first, although the buttons will work.

all you need to do is filter the records outside of the SQL statement by highlighting the recordset in the bindings window and selecting > goto specific record. fill in your info, and it is now navigatable.

any probs let me know

if you need a more descriptive solution refer to my other post, i just didnt want to type it all out again.
www.dmxzone.com/forum/topic.asp?TOPIC_ID=28392&FORUM_ID=2&CAT_ID=2&Topic_Title=Can+you+combine+behaviours%3F&Forum_Title=Dreamweaver

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Thanks mate...Works like a dream.