SQL1 = "SELECT TOP 5 * FROM anv ORDER BY loggain DESC, anv"
Set Rs = Connect.Execute(SQL[b]1[/b])
Du kan återanvända dina SQL direkt efter att den blivit exekverad.
Frågan#1
Varför säger den detta:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/start.asp, line 68
Så här ser koden ut:
<%
SQL1 = "SELECT TOP 5 * FROM anv ORDER BY loggain DESC, anv"
Set Rs = Connect.Execute(SQL)
Do Until Rs.EOF
Response.Write "<tr>"
68-->Response.Write "<td width=100 align=left><font size=""1"">"& Rs("anv") & "</td>"
Response.Write "<td width=200 align=center><font size=""1"">" & Rs("loggain") & "</td>"
Response.Write "</tr>"
Rs.MoveNext
Loop
%>
Jag vill se vilka som senast loggade in! Kolumnen heter "anv" så varför fungerar det inte?