ASP trubbel

Hej!

Jag får detta felmeddelandet:
Microsoft OLE DB Provider for ODBC Drivers error ''80040e09''

[TCX][MyODBC]You have an error in your SQL syntax near ''8 FROM laggtilllank ORDER BY id DESC'' at line 1

/Default.asp, line 138

På denna koden:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver=MySQL;DB=ol_netwo_f;SERVER=ol-networks.com;UID=ol_netwo;PWD=blabla;"
Set RecSet = Server.CreateObject("ADODB.Recordset")
SQLVisa = "SELECT TOP 8 * FROM laggtilllank ORDER BY id DESC" <-- Detta är rad 138
Recset.Open SQLVisa, Conn
Do until RecSet.EOF
Response.Write "<a href=" & RecSet("url") & ">" & RecSet("titel") & "<br>"
RecSet.Movenext
Loop
Conn.Close
Set Conn=nothing
RecSet.Close
Set RecSet=nothing

Jag vore oerhört tacksam om någon visste vad problemet är/kan vara.

Mysql stöder inte konstruktionen med select top 8. I stället så får man skriva

   SQLVisa = "SELECT * FROM laggtilllank ORDER BY id DESC limit 8"

btw, arriva ahiba aha.

------------------
essentitia preter non sans multiplicandum

Tack!