recordset problem

Hi all
Need some help with this1 
i have made recordset for news on main page.
<%
Dim news
Dim news_numRows
Set news = Server.CreateObject("ADODB.Recordset")
news.ActiveConnection = MM_artek_STRING
news.Source = "SELECT * FROM news_"& Session("lang") + " ORDER BY ID DESC"
news.CursorType = 0
news.CursorLocation = 2
news.LockType = 1
news.Open()

news_numRows = 0
%>

The thing is, I have mulitlanguage page therefor I have some problems with writing right recordset in detail page. (Table names in db: news_si and news_en)



Detail page recordset:
<%
Dim news
Dim news_numRows

Set news = Server.CreateObject("ADODB.Recordset")
news.ActiveConnection = MM_artek_STRING
news.Source = "SELECT * FROM news_"& Session("lang") don't know what to write here exactly
news.CursorType = 0
news.CursorLocation = 2
news.LockType = 1
news.Open()

news_numRows = 0
%>

Now what I would like is, that once you click on the news ( let say ID=4) to go to news.asp?ID=4,  but when i click the link, it goes to ID=1.
At the moment I add 4 news. On main page I only display last news, on the news page all news are displayed.

Also in news.asp page, where all news links alre dispalyed it will go to ID=1.
I think I should right somethin for URL parameters, but I just dont know how.

Thanks,

Ok,

I have wrote my post a little wrong so my apologiez .
The first recordset ( default page )is working partly, cuz once u click on a news link it will always point you to the first news in news.asp page entered in DB.

I have made complete link in default page: <a href="news.asp?ID=<%=(news.Fields.Item("id").Value)%>"><%=(news.Fields.Item("title").Val ue)%>


The news.asp page is the one I'm having bigger problems!

The thing is that I have made 2 recordsets in news.asp page! ( news and news1)-
first one(news) is for displaying Title, text and image of the specific news u have clicked and second(news1) to display only news title of all news that are in DB!

So what I would need is only to fix the recordset so it will point you to the right ID not always to #1 ( in default page and news.asp page), cuz Session("lang") is set and working fine.

Here are my recordsets in news.asp page:
<%
Dim news
Dim news_numRows

Set news = Server.CreateObject("ADODB.Recordset")
news.ActiveConnection = MM_artek_STRING
news.Source = "SELECT * FROM news_"& Session("lang") -as far as I was reading I must add something here but don't know what
news.CursorType = 0
news.CursorLocation = 2
news.LockType = 1
news.Open()

news_numRows = 0
%>



<%
Dim news1
Dim news1_numRows

Set news1 = Server.CreateObject("ADODB.Recordset")
news1.ActiveConnection = MM_artek_STRING
news1.Source = "SELECT * FROM news_"& Session("lang") -as far as I was reading I must add something here but don't know what
news1.CursorType = 0
news1.CursorLocation = 2
news1.LockType = 1
news1.Open()

news1_numRows = 0
%>

personally id still make sure theres a Session("lang") value set

so its best to have the way i said

and am not quite sure wots going on with "news__MMColParam"

if you want your page to show the news artical you clicked on you do

intNewsID = Request.QueryString("ID")
if isNumeric(intNewsID) then intNewsID = clng(intNewsID) else intNewsID = 0

this will get the number from "news.asp?id=1"
the if isNumeric() is a security check to stop people hacking your site

so you'd have:

news.Source = "SELECT * FROM news_" & strLang  & " WHERE ID = " & intNewsID & ";"