How to lookup/compare a value in a table..

[plumba]

I have a table in a HTML form which has multiple rows, each row contains a user ID (too many to list on this forum).. The form has an input field at the top which the user types in a user ID, I want the form to compare this to the table. If there is a match to return true, if there is no match to return cancel.

I would user an onchange to call the javascript function.

Hope that's enough to go on, I shoul be able to modify any type of example to work... Basically though, it need to compare one field to the rows in the table and find a match.

Any suggestions greatly appreciated..

[acoder]

See this example.

[iam_clint]

or you can try to modify this code i made for reading tables like excel

http://www.thescripts.com/forum/thread646585.html

[plumba]

or you can try to modify this code i made for reading tables like excel

http://www.thescripts.com/forum/thread646585.html

Thanks for the suggestions but I'm still getting no joy.

I've now modified the page slightly, all the values are in a select box called 'userid'. The user then puts in an ID in a text box called '1stDefinition''. The script should then se if the text entered in the 'existingid' field matches up to of the options in the 'userid' select box - regardless of which option is selected - it should make no difference as the select box will be hidden and is used only for this check.

The script I have so far is:

function compareID(){
 
var idlist = document.getElementById('1stDefinition').value;
var idinput = document.getElementById('existingid');
 
alert(idlist);
alert(idinput.value);
 
if (idlist == idinput.value){
    alert("Match");
    }else{
    alert("No match");
    }
 
 
}

So you can see it only looks up the selected option in the '1stDefinition' select box - it should step through the whole lot to see if there is a match.

Regards

[iam_clint]

I think this is more what you was looking for

it loops through the options and compairs each value.

function compareID() {
var idlist = document.getElementById('1stDefinition').options;
var idinput = document.getElementById('existingid');
var match = false;
for (i=0; i<idlist.length; i++) {
  if (idlist[i].value.toLowerCase() == idinput.value.toLowerCase()){ match = true;  }
} 
if (match) { alert("match"); } else { alert("no match"); }
}
 

[plumba]

I think this is more what you was looking for

it loops through the options and compairs each value.

function compareID() {
var idlist = document.getElementById('1stDefinition').options;
var idinput = document.getElementById('existingid');
var match = false;
for (i=0; i<idlist.length; i++) {
  if (idlist[i].value.toLowerCase() == idinput.value.toLowerCase()){ match = true;  }
} 
if (match) { alert("match"); } else { alert("no match"); }
}
 

Hi, many thanks for that, the code seems to make sense but IE is throwing back an error saying that on a line in the form an object is expected, this line:

[HTML]<input type="button" onClick="compareID();" value="Compare">[/HTML]

That is the line which contains the button which calls the function and nothing else........ any sugestions??

[iam_clint]

Well the code i gave you works

<script>
function compareID() {
var idlist = document.getElementById('1stDefinition').options;
var idinput = document.getElementById('existingid');
var match = false;
for (i=0; i<idlist.length; i++) {
  if (idlist[i].value.toLowerCase() == idinput.value.toLowerCase()){ match = true;  }
} 
if (match) { alert("match"); } else { alert("no match"); }
}
</script>
<input type="text" onblur="compareID();" value="" id="existingid"><select id="1stDefinition" name="1stDefinition"><option value="test">test</option><option value="apple">apple</option><option value="orange">orange</option></select>
 
 

theres my test page for it


So something your doing or something has changed.