Validate user entry against table column

[Paulette]

Fairly new to the ASP/Javascript game. Have my connectivity to a SQL db, user
will enter in a membership number. I need to verify validity of their entry
against a column in a table, and if invalid - sends user to a different page.


I've poured over many archives looking for something similar - can anyone
help me get going?

Thanks.

[Paulette]

I figured out a way to do this (and it works) - so thought I'd share my resolution.

On the ASP page, if a member enters a membership number not in the database
it redirects an unsuccessful login to an error page (which is similar to
most login type of pages). Ended up being a very simple solution.

"Paulette" <webdev.@127.0.0.1> wrote:
>
>Fairly new to the ASP/Javascript game. Have my connectivity to a SQL db,
user
>will enter in a membership number. I need to verify validity of their entry
>against a column in a table, and if invalid - sends user to a different
page.
>
>
>I've poured over many archives looking for something similar - can anyone
>help me get going?
>
>Thanks.