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.