<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "databasen"

Set RecSet = Server.CreateObject("ADODB.Recordset")

Addera = "Select TOP 15 *, From members WHERE status=1 ORDER BY datum_inloggning DESC"

RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic
Do Until RecSet.EOF
%>
<%=RecSet("enamn")%>
<%
RecSet.MoveNext
Loop
RecSet.Close
Connect.Close
Set RecSet = nothing
Set Connect = nothing
%>

får detta felmeddelandet:
Microsoft OLE DB Provider for ODBC Drivers fel '80040e21'

The request properties can not be supported by this ODBC Driver.

/community1/aaa/inne.asp, rad 134


På rad 134 så står det:
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic

MySQL stöder inte TOP, tror funktionen du ska använda heter LIMIT.

/Johan

Tackar!

Bytte ut select-strängen till:
Select * From members WHERE status=1 ORDER BY datum_inloggning DESC LIMIT 0, 15;