Validating Text field against database.

[chandhseke]

I have developed a web page using ASP classic, I am using VBScript for database connectivity... The web application is working fine, but i am now working on a new enhancement requirement where i need to validate the ID# entered into a text box by the users against a new database. This validation should happen as soon as the User enters his ID#.

Once the user enters the ID#, it should check the availabity of the ID# in the database table, if it does not exists a Message should pop up saying "Invalid ID number entered"

Here is the code for your review.

<tr>
<td bordercolor="#F FFFFF" bgcolor="#33339 9"> <div align="center"> <font color=#FFFFFF
size=2 face="Verdana, Arial, Helvetica, sans-serif"><strong> PeopleSoft ID</strong></font></div></td>
<td bordercolor="#F FFFFF"> <input maxlength=6 size=13 name=ID />
</td>
</tr>

In the above sample code snippet, we need to add validation against database..And this validation should happpen before the form submission

[chandhseke]

Thanks for your kind help on guiding me to the correct point..

Many thanks