Hi there!

I have a news section on my page, a repeat region that shows 2 news at a time.
What I would like to do is make a link so that people can click and read the
rest of the news that they choose.

I have tried making the link dynamic and make a connection to the id of that
news, but I only seem to get the first news in the database (Access)

Think maybe the error is with the recordset filtering, but cannot figure it out.

Suggestions, anyone?


Regards, Christian

Help is only a click away...
~~~~~~~~~~~~~~~~~
DWMX2004 | ASP | Access

Ok, I got i figured out.

just used the following link:

<pre id=code><font face=courier size=2 id=code> mypage.asp?&lt; %= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "id=" & RSNewsFeed.Fields.Item("id".Value % &gt; </font id=code></pre id=code>


Took me a while though <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


C

Help is only a click away...
~~~~~~~~~~~~~~~~~
DWMX2004 | ASP | Access

Edited by - Sarre on 29 Sep 2005 00:11:52

This didn't work out as well as I planned..
Maybe someone else knows a better way to do this?



Help is only a click away...
~~~~~~~~~~~~~~~~~
DWMX2004 | ASP | Access

All you should need to do is link to mypage.asp with the link mypage.asp?article=" & RSNewsFeed.Fields.Item("id".Value & " then on mypage.asp you will need some sql to get the news from the DB, the sql should be something like this

sql="select news_title, news_content from table name where id = request("article""

Hope this makes some sense to you

Wayne

It sure makes more sense now.
I didn't think about the sql-part on the second page.

Works fine now, thank you very much <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards, Christian


Help is only a click away...
~~~~~~~~~~~~~~~~~
DWMX2004 | ASP | Access