Double Combo Box to database

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top