10 tilfældige links fra access

Mener du kan gøre sådan:

select link from table order by rand() limit 10;

Et eksempel på hvordan man vælger et tilfældigt tip:
http://www.activeserverpages.dk/aspdigital/kapitel1/randomtip.asp
DEt kan vel hurtigt tilpasses?

Jeg har prøvet dette:

<%
strSQL = \"SELECT TOP 5 * FROM links order by rand;\"
    Set myConn = Server.CreateObject(\"ADODB.Connection\")
    myConn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"../opgaver/database.mdb\") & \";UID=admin;PWD=;\"
    Set rs = myConn.Execute(strSQL)
    If Not (rs.BOF Or rs.EOF) Then
        Do While Not rs.EOF   
Response.Write\"- <a href=\'\" & rs(\"LinkURL\") & \"\'>\" & rs(\"LinkName\") & \"</a> <br>\"

            rs.MoveNext
        Loop

    Else
        Response.Write \"<p><font face=Tahoma size=1>There are no new articles in the database</font></p>\"
    End If
    myConn.Close
    Set myConn = Nothing
%>

Men det virker ligesom ik helt...

prøv at det her:

<%
strSQL = \"SELECT TOP 5 * FROM links order by rand;\"
    Set myConn = Server.CreateObject(\"ADODB.Connection\")
    myConn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"../opgaver/database.mdb\") & \";UID=admin;PWD=;\"
    Set rs = myConn.Execute(strSQL)
    If Not (rs.BOF Or rs.EOF) Then
        Do While Not rs.EOF   
Linkurl = rs(\"LinkURL\")
LinkName = rs(\"LinkName\")
Response.Write\"<a href=\" & LinkURL & \">\" LinkName & \"</a><br>\"

            rs.MoveNext
        Loop

    Else
        Response.Write \"<p><font face=Tahoma size=1>There are no new articles in the database</font></p>\"
    End If
    myConn.Close
    Set myConn = Nothing
%>

Det virker for mig

Men ikke for mig :( Lukker nu. Tak for alle svarene !