buckinator
Technical User
I have a code that has two select boxes. You choose your options that are listed in the first select box and then submit them to the second select box as your choices. When I hit the submit button, the choices do not pass over to the action page. A copy of the code is pasted below. Could someone review the code and see if they could tell me why the selected items are not passing over to the action form. Thanks.
<cfquery name="CustomerList_2001R1" datasource="Survey" dbtype="ODBC">
SELECT Customer, BEMSID
FROM All_Depts
ORDER BY Customer, BEMSID</cfquery>
<!---
<table align="center">
<tr bgcolor="#0000FF">
<td><strong>Customer</strong></td>
<td><strong>BEMSID</strong></td>
</tr>
<cfoutput query="CustomerList_2001R1">
<tr>
<td>#Customer#</td>
<td>#BEMSID#</td>
</tr>
</cfoutput>
</table>
--->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>ENGINEERING CUSTOMER LIST</title>
<script type="text/javascript">
function OnTransferBtnClick(blnFromLeft)
{
var LeftListBox = document.forms[0].lstLeft;
var RightListBox = document.forms[0].lstRight;
var ListItems = new Array();
FromList = (blnFromLeft ? LeftListBox : RightListBox);
ToList = (blnFromLeft ? RightListBox : LeftListBox);
for(var i=(FromList.options.length - 1);i>=0;i--)
if(FromList.options.selected)
{
ListItems[ListItems.length] = new Option(FromList.options.text);
FromList.options = null;
}
<!----Added the following for loop to replace this for loop
for(var i=ListItems.length - 1;i>=0;i--)
ToList.options[ToList.options.length] = ListItems;
--->
for(var i=ListItems.length - 1;i>=0;i--) {
ToList.options[ToList.options.length - 1] = ListItems;
ToList.options.length++;
}
}
function OnBtnSubmitClick(f)
{
ListBox = document.forms[0].lstRight;
alert("lstbox" + f.lstRight.options[0].text);
if(ListBox.options.length==0){
alert("You did not selection any item/items. Please choose an item/items from the left list box and transfer them to the right list box"
;
}
else
{
f.submit();
}
}
</script>
</head>
<body bgColor="#FFFFF0">
<form action="insert3.cfm" method="post" name="f" id="f">
<input type="hidden" name="test" value="testing">
Please Choose Your Engineering Boeing Customer(s)
<table>
<tr>
<td>
<select name="lstLeft" MULTIPLE size="15">
<cfoutput query="CustomerList_2001R1">
<Option value="#BEMSID#">#Customer#</cfoutput>
</select>
</td>
<td>
</td>
<td>
<table>
<tr>
<td>
<input Type="Button" Name="btnLtoR" Value=" >> "
onclick="OnTransferBtnClick(true)" title="Transfer Items Selected in the
Left List Box to the Right List Box">
</td>
</tr>
<tr>
<td>
<input Type="Button" Name="btnRtoL" Value=" << "
onclick="OnTransferBtnClick(false)" title="Transfer Items Selected in the
Right List Box to the Left List Box">
</td>
</tr>
</table>
</td>
<td>
</td>
<td>
<select name="lstRight" MULTIPLE size="15">
<Option>    
</select>
</td>
</tr>
<tr>
<td>
<input type="button" name="btnSubmit" value="OK" onClick="OnBtnSubmitClick(this.form);">
</td>
</tr>
</table>
</form>
</body>
</html>
(Action Page Code)
<html>
<head>
<title>Untitled</title>
</head>
<body>
<cfoutput>
The customer list is:#form.lstRight#
</cfoutput>
<cfoutput>
<p>Customers selected are:#REMOTE_ADDR#
<P>Test=#testing#
</cfoutput>
</body>
</html>
<cfquery name="CustomerList_2001R1" datasource="Survey" dbtype="ODBC">
SELECT Customer, BEMSID
FROM All_Depts
ORDER BY Customer, BEMSID</cfquery>
<!---
<table align="center">
<tr bgcolor="#0000FF">
<td><strong>Customer</strong></td>
<td><strong>BEMSID</strong></td>
</tr>
<cfoutput query="CustomerList_2001R1">
<tr>
<td>#Customer#</td>
<td>#BEMSID#</td>
</tr>
</cfoutput>
</table>
--->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>ENGINEERING CUSTOMER LIST</title>
<script type="text/javascript">
function OnTransferBtnClick(blnFromLeft)
{
var LeftListBox = document.forms[0].lstLeft;
var RightListBox = document.forms[0].lstRight;
var ListItems = new Array();
FromList = (blnFromLeft ? LeftListBox : RightListBox);
ToList = (blnFromLeft ? RightListBox : LeftListBox);
for(var i=(FromList.options.length - 1);i>=0;i--)
if(FromList.options.selected)
{
ListItems[ListItems.length] = new Option(FromList.options.text);
FromList.options = null;
}
<!----Added the following for loop to replace this for loop
for(var i=ListItems.length - 1;i>=0;i--)
ToList.options[ToList.options.length] = ListItems;
--->
for(var i=ListItems.length - 1;i>=0;i--) {
ToList.options[ToList.options.length - 1] = ListItems;
ToList.options.length++;
}
}
function OnBtnSubmitClick(f)
{
ListBox = document.forms[0].lstRight;
alert("lstbox" + f.lstRight.options[0].text);
if(ListBox.options.length==0){
alert("You did not selection any item/items. Please choose an item/items from the left list box and transfer them to the right list box"
;}
else
{
f.submit();
}
}
</script>
</head>
<body bgColor="#FFFFF0">
<form action="insert3.cfm" method="post" name="f" id="f">
<input type="hidden" name="test" value="testing">
Please Choose Your Engineering Boeing Customer(s)
<table>
<tr>
<td>
<select name="lstLeft" MULTIPLE size="15">
<cfoutput query="CustomerList_2001R1">
<Option value="#BEMSID#">#Customer#</cfoutput>
</select>
</td>
<td>
</td>
<td>
<table>
<tr>
<td>
<input Type="Button" Name="btnLtoR" Value=" >> "
onclick="OnTransferBtnClick(true)" title="Transfer Items Selected in the
Left List Box to the Right List Box">
</td>
</tr>
<tr>
<td>
<input Type="Button" Name="btnRtoL" Value=" << "
onclick="OnTransferBtnClick(false)" title="Transfer Items Selected in the
Right List Box to the Left List Box">
</td>
</tr>
</table>
</td>
<td>
</td>
<td>
<select name="lstRight" MULTIPLE size="15">
<Option>    
</select>
</td>
</tr>
<tr>
<td>
<input type="button" name="btnSubmit" value="OK" onClick="OnBtnSubmitClick(this.form);">
</td>
</tr>
</table>
</form>
</body>
</html>
(Action Page Code)
<html>
<head>
<title>Untitled</title>
</head>
<body>
<cfoutput>
The customer list is:#form.lstRight#
</cfoutput>
<cfoutput>
<p>Customers selected are:#REMOTE_ADDR#
<P>Test=#testing#
</cfoutput>
</body>
</html>
