Mutii Select Lists

jacob94 · Jun 7, 2006

I created a very very simple form in Dreamweaver MX using ASP VB Script. I have 6 drop down select list that have the same static lists.

I have a update button that updates a record in my database. All I want to do is add a piece of code that checks to see if the user picked the same choice for two boxes, if they do flash a message saying they need to be unique and not allowing the record to be updated.

With all the code that gets generated from DW when I build the recordset and update statement, I am not sure where to place this code or how to even write it.

Can someone show me an example and where I should place it?

request(Select1 - 6)
If anyone of them are the same, show error message else update record.

Thanks!

Cheech · Jun 8, 2006

You just need to add an onChange javascript function to each menu that will check the values of all of the other menus. Have a look at the code below that I quickly knocked up and see what it does, before using it post it into the javascript forum on here and ask someone to tidy it up though

Code:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<script  language="javascript">
function checkMenu(){
var opt1 = document.forms.form1.select1.value
var opt2 = document.forms.form1.select2.value
var opt3 = document.forms.form1.select3.value
var opt4 = document.forms.form1.select4.value
if (opt1 != 0) {
if (opt1 == opt2){
alert("Selections must be unique!!");
return;
}
if (opt1 == opt3){
alert("Selections must be unique!!");
return;
}
if (opt1 == opt4){
alert("Selections must be unique!!");
return;
}
}
if (opt2 != 0) {
if (opt2 == opt1){
alert("Selections must be unique!!");
return;
}
if (opt2 == opt3){
alert("Selections must be unique!!");
return;
}
if (opt2 == opt4){
alert("Selections must be unique!!");
return;
}
}
if (opt3 != 0) {
if (opt3 == opt1){
alert("Selections must be unique!!");
return;
}
if (opt3 == opt2){
alert("Selections must be unique!!");
return;
}
if (opt3 == opt4){
alert("Selections must be unique!!");
return;
}
}
if (opt4 != 0) {
if (opt4 == opt1){
alert("Selections must be unique!!");
return;
}
if (opt4 == opt2){
alert("Selections must be unique!!");
return;
}
if (opt4 == opt3){
alert("Selections must be unique!!");
return;
}
}
}
</script>
</head>

<body>
<form name="form1" method="post" action="">
  <select name="select1" onChange="checkMenu()">
    <option value="0">** Please Select **</option>  
    <option value="1">Option1</option>
    <option value="2">Option2</option>
    <option value="3">Option3</option>
    <option value="4">Option4</option>
    <option value="5">Option5</option>
    <option value="6">Option6</option>
    <option value="7">Option7</option>
    <option value="8">Option8</option>
    <option value="9">Option9</option>
    <option value="10">Option10</option>
    <option value="11">Option11</option>
  </select>
  <select name="select2" onChange="checkMenu()">
    <option value="0">** Please Select **</option>
    <option value="1">Option1</option>
    <option value="2">Option2</option>
    <option value="3">Option3</option>
    <option value="4">Option4</option>
    <option value="5">Option5</option>
    <option value="6">Option6</option>
    <option value="7">Option7</option>
    <option value="8">Option8</option>
    <option value="9">Option9</option>
    <option value="10">Option10</option>
    <option value="11">Option11</option>
  </select>
  <select name="select3" onChange="checkMenu()">
    <option value="0">** Please Select **</option>
    <option value="1">Option1</option>
    <option value="2">Option2</option>
    <option value="3">Option3</option>
    <option value="4">Option4</option>
    <option value="5">Option5</option>
    <option value="6">Option6</option>
    <option value="7">Option7</option>
    <option value="8">Option8</option>
    <option value="9">Option9</option>
    <option value="10">Option10</option>
    <option value="11">Option11</option>
  </select>
  <select name="select4" onChange="checkMenu()">
    <option value="0">** Please Select **</option>
    <option value="1">Option1</option>
    <option value="2">Option2</option>
    <option value="3">Option3</option>
    <option value="4">Option4</option>
    <option value="5">Option5</option>
    <option value="6">Option6</option>
    <option value="7">Option7</option>
    <option value="8">Option8</option>
    <option value="9">Option9</option>
    <option value="10">Option10</option>
    <option value="11">Option11</option>
  </select>
</form>
</body>
</html>

Cheech

[Peace][Pipe]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Mutii Select Lists

jacob94

Technical User

Cheech

Technical User

Similar threads

Part and Inventory Search

Sponsor