Activation Field.

AfterSuccessfulLogin is correct event for this purpose.

This is a follow up on this post.
I can't seem to get redirection to work. Probably not doing it right.
In the AfterSuccessfulLogin Event I am using this code:
if dict("activated") = 0 then

response.redirect("changepwd.asp")

end if
If I remove the DICT part and just use activated, then everyone is redirected. Even if the value = 1, which means the account IS activated.
Avtivated is a BIT column and is in fact Zero for an account that I tested.
Thanks

AfterSuccessfulLogin event doesn't have dict parameter. You need to run SQL query using username and password as an argument to retrieve the value of Activated field.

Yes sir, that's what we did. Created a recordset, grabbed it up and all was well. We now know how to do this. Many of the pointers and code frags throughout this site and from you helped.
Thanks.

Can someone explain to me how to do this?

"Run SQL query using username and password as an argument to retrieve the value of Activated field"
I have an app that I want to give a temporary password to the users, then force them to change their passwords.
Thanks

Something Like this will do the trick:
dim rs, strSQL
strSQL = "Select Column1, Column2, ColumnX from TABLENAME "

strSQL = strSQL & "WHERE CONDITION ='" & StringToFind & "'"
Set rs = Server.CreateObject("ADODB.Recordset")

rs.Open strSQL, EW_DB_CONNECTION_STRING, 1, 2
' create session variables to be used later

session("strStatus") = rs("Acct_Status")

session("strActive") = rs("Activated")
rs.Close

Set rs = Nothing

Thank you Wanda. I will give that a try.

Something Like this will do the trick: