S
SS
Hi
I have the following code which I found on the web which is great except the
information from the second box is not submitted to the database only the
first one. The information of the second box is also not displayed on the
confirmation page.
<body>
<form name="doublecombo" action="--WEBBOT-SELF--" method="POST">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="DropDown3" S-RecordSource="Results"
U-Database-URL="../../../fpdb/DropDown3.mdb"
S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER"
S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name"
S-Form-Fields="stage2 example Name" S-Form-DBFields="stage2 example Name"
startspan U-ASP-Include-Url="../../../_fpclass/fpdbform.inc" --><input
TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="../../../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase"
endspan i-checksum="52631" -->
<p><select name="example" size="1"
onChange="redirect(this.options.selectedIndex)">
<option>Departments</option>
<option>Dept1</option>
<option>Dept2</option>
</select>
<select name="stage2" size="1"
onChange="redirect(this.options.selectedIndex)">
<option>Cost Centre Codes</option>
<option value="557420">557420</option>
<option value="557123">557123</option>
</select>
</p>
<p><input type="submit" name="test" value="Go!"
onClick="go()">
</p>
<script>
<!--
/*
Double Combo Script Credit
By JavaScript Kit (www.javascriptkit.com)
Over 200+ free JavaScripts here!
*/
var groups=document.doublecombo.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group=new Array()
group[0][0]=new Option("","")
group[0][1]=new Option("","")
group[0][2]=new Option("","")
group[1][0]=new Option("557420","")
group[2][0]=new Option("557123","")
var temp=document.doublecombo.stage2
function redirect(x){
for (m=temp.options.length-1;m>0;m--)
temp.options[m]=null
for (i=0;i<group[x].length;i++){
temp.options=new Option(group[x].text,group[x].value)
}
temp.options[0].selected=true
}
function go(){
location=temp.options[temp.selectedIndex].value
}
//-->
</script>
</form>
Any ideas would be great
I have the following code which I found on the web which is great except the
information from the second box is not submitted to the database only the
first one. The information of the second box is also not displayed on the
confirmation page.
<body>
<form name="doublecombo" action="--WEBBOT-SELF--" method="POST">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="DropDown3" S-RecordSource="Results"
U-Database-URL="../../../fpdb/DropDown3.mdb"
S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER"
S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name"
S-Form-Fields="stage2 example Name" S-Form-DBFields="stage2 example Name"
startspan U-ASP-Include-Url="../../../_fpclass/fpdbform.inc" --><input
TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="../../../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase"
endspan i-checksum="52631" -->
<p><select name="example" size="1"
onChange="redirect(this.options.selectedIndex)">
<option>Departments</option>
<option>Dept1</option>
<option>Dept2</option>
</select>
<select name="stage2" size="1"
onChange="redirect(this.options.selectedIndex)">
<option>Cost Centre Codes</option>
<option value="557420">557420</option>
<option value="557123">557123</option>
</select>
</p>
<p><input type="submit" name="test" value="Go!"
onClick="go()">
</p>
<script>
<!--
/*
Double Combo Script Credit
By JavaScript Kit (www.javascriptkit.com)
Over 200+ free JavaScripts here!
*/
var groups=document.doublecombo.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group=new Array()
group[0][0]=new Option("","")
group[0][1]=new Option("","")
group[0][2]=new Option("","")
group[1][0]=new Option("557420","")
group[2][0]=new Option("557123","")
var temp=document.doublecombo.stage2
function redirect(x){
for (m=temp.options.length-1;m>0;m--)
temp.options[m]=null
for (i=0;i<group[x].length;i++){
temp.options=new Option(group[x].text,group[x].value)
}
temp.options[0].selected=true
}
function go(){
location=temp.options[temp.selectedIndex].value
}
//-->
</script>
</form>
Any ideas would be great