SQL - query for True or False records

Problem solved. Just filter the records after you select them:

sSQL = "Select * from Usuarios order by nome asc"       

set RStemp = createobject("adodb.recordset")
set RStemp.activeconnection = usersDB

regs = 10
pag = 1

RStemp.cursortype = 3
RStemp.pagesize = regs
RStemp.open sSQL
TotalInscritos = RStemp.RecordCount
RStemp.filter = "user-block = TRUE"

I hope the solution is useful for others

The correct one in your sql would be:

Select * from Usuarios WHERE [user-block]=true order by NOME asc

simply because of the dash ( - ) you have to put brackets ( [ and ] ), and it would not be very cool to do so, with underscore , that is, dash underneath example user_block , but that would solve your doubts.

Complete Code

<%

    dim connection
    dim result

    set connection = Server.CreateObject("ADODB.Connection")
    set result = Server.CreateObject("ADODB.recordset")

    connection.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\adm.mdb"


    result.Open "SELECT * FROM Usuarios WHERE [user-block]=true", connection



    Do While Not result.EOF
        Response.Write(result.Fields("Id") & " - ")
        Response.Write(result.Fields("Nome") & " - ")
        Response.Write(result.Fields("user-block"))
        Response.Write("<br />")

        result.MoveNext
    Loop

    connection.Close
    set connection = Nothing
%>

• Underscore
• ADO - How to use the Connection object?
• ASP and ADO - Placing your database on the WEB
• Working with Recordsets - Changing and Returning Data.
• Using the Recordset with MS Access and ADO