I need to compare a value typed into a form field against a list queried from a database to ensure duplicate information is not submitted. This is part of a very long form so I'd like to find a way to alert the user that this field contains a duplicate as a pre-post validation rather than validating it during the form's action and sending the user back to a blank form to start over.

This is an edit to an existing hosted application so I'm trying to keep actual code changes to a minimum.

thanks

<script language="javascript">
function ckkcom()
{
   if(document.form1.txt1.value==document.form1.txt2. value){
             alert("duplicate values found")
       }
}
</script >
<form name="form1" method="post">
text box 1
<input type="text" name="txt1">

text box 2
<input type="text" name="txt2">

<input type="button" value="Submit" onclick="javascript:ckkcom()" name="btnadd">
</form>

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

thanks - that's great for comparing two individual form fields. I need to compare one form field to all values in a recordset before page submission. I'm not even sure this can be done but I was thinking that it might be possible to poll the DB and get the recordset I need, then compare the form field value the user enteres to each db recordset value as an array... then again, I'm not exactly array savvy so I don't know if this can all be done client-side before the form data moves along its merry way.

yah chelle60,
you can try with ajax, it will help you. it will work client site, ajax will run html, so you can contact the server using ajax tec. learn about ajax using my blog http://ssuren.spaces.msn.com or www.w3schools.com

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com