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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mutii Select Lists

Status
Not open for further replies.
jacob94

jacob94

Technical User
Joined
Dec 5, 2005
Messages
161
Location
US
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!
 
Sort by date Sort by votes
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]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JaniseD
  • Locked
  • Question Question
CF Multi-Select Box Not Displaying Values Passed From Grid?
Replies
1
Views
356
JaniseD
JaniseD
pixiesfb
  • Locked
  • Question Question
Select Certificate, Windows 7, Office 2010
Replies
0
Views
208
pixiesfb
pixiesfb
JohnShell
  • Locked
  • Question Question
cfgrid row select
Replies
1
Views
267
murphyhg
murphyhg
sinbad99
  • Locked
  • Question Question
Multi-selecting urls
Replies
0
Views
178
sinbad99
sinbad99
jenmerr
  • Locked
  • Question Question
Query to Select the Top Value
Replies
13
Views
501
r937
r937

Part and Inventory Search

Sponsor

Back
Top