I am trying to compare a record (active) field. If the field is no then send the user to a not active page and if it is yes, send the user to the main page. This is what I have so far:

<!--#include file="inc/requestcookies. asp"-->
<!--#include file="inc/common.inc"-->
<%
strSQL = "SELECT * FROM memberslist WHERE username = '" & username & "'"
...