Lista med alla som har...

löste det med denna:

<table border="0" width="238" cellpadding="0" cellspacing="0" height="1" align="left">
   <tr>
    <td width="150" height="1"><b><font size="2">Användare</font></b></td>
      </tr><font size="2"> Blockerade i klotter
<%
SQL1 = "SELECT TOP 5 * FROM anv Where blockadklotter = true"

Set Rs = Connect.Execute(SQL1)
Do Until Rs.EOF
Response.Write "<tr>"
Response.Write "<td width=150 align=left><font size=""1"">"&  Rs("anv") & "</td>"
Response.Write "</tr>"
Rs.MoveNext

Loop

%></td>
</form>
</tr>
  </font></table>

fast nu visas bara 5 hur får man alla?

strSQL = "SELECT * FROM anv WHERE blockadklotter = true"
objRS.Open strSQL, objCon
----------------------------------------------------------------------------
If NOT objRS.EOF Then
  Do Until objRS.EOF
    Response.Write("Blockade:<br>" & vbCrLf & objRS("anv") & "<br>")
    objRS.MoveNext
  Loop
End If

Tack!

SQL1 = "SELECT TOP 5 * FROM anv Where blockadklotter = true"

Finn 5 fel. ;)