Validate enum field

I am creating a login page. I have three fields to validate, "username", "password" and "active". My "active" field is designated as enum and I need to validate that it contains 'y'. I set "active" as a hidden input in the form. The visitor logging will not enter this value. When the Authenticate User wizard finishes, the value for the enum column type = $WA_Auth_Separator."" (or blank)

When I try to use the login, I get a error message that states "Unknown column 'y' in 'where clause". If I change the column type to "text", I do not get the error, but it doesn't validate the field.

How do I validate an enum field?
I have attached the page code.

Since you want the value on registration to be y, you should set the default value for that column to y in the database, then don't include it in the registration at all, it will always be y if no value is passed.

I'm sorry, I don't think I explained myself properly. This is not a registration but a login. When the user logs in, if their "active" field does not contain 'y', the login should fail.

you wont be able to do that through a hidden field, you cant populate the login form with the users details before they have logged in.

instead, you should edit the authenticate user sever behavior, on the session tab, set the active column to save to a session on login.

then create an access rule based on the active session;

allow if: session active = y

thank you Jason, your help is always appreciated...I will use a session value... I was just hoping I could validate all three at the same time...