if not Session("donotdo") = 1 then
        SQLStr="SELECT TOP 10 * FROM ORArticles WHERE ORDER by MagID DESC"
        Set RS=Server.CreateObject("ADODB.Recordset")
        RS.Open SQLStr,Application("DBConn"),adOpenKeyset,adLockPe ssimistic,adCmdText
    else
        SQLStr="SELECT TOP 10 * FROM ORArticles WHERE ArticleID=" & Session("GlobalArticleID") & " ORDER by MagID DESC"
        Set RS=Server.CreateObject("ADODB.Recordset")
        RS.Open SQLStr,Application("DBConn"),adOpenKeyset,adLockPe ssimistic,adCmdText
    end if

This code was already present, it only brings up the same article everytime, I want it to choose a random article every time the page is loaded. Is there something that can be added to the code to change articles??

Thanks

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason

What database are you using? If you're using SQL Server, you can try this:

SELECT TOP 10 Column1 FROM MyTable ORDDER BY NewID()

This will generate a GUID for each record, and order by that GUID.


HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Well hot dog!

I hadn't thought of that one! That works pretty well!

Great call Imar!

Peter
------------------------------------------------------
Work smarter, not harder.

Thank you I will give it a try, and it is an SQL DB

Thanks again

Thanks guys it works great :)