Multiple Select boxes in one form

Check out qForms for making select controls based on a previous select control.

I did try isdefined and here is my code below. Should I write it in six different cfif's? I only want the user to select one box and hit the submit button. Here is the code I have for the isdefined function.

If you want to take a look at what I am doing go to www.legis.state.wv.us/cainr/bill_status/bill_status.cfm. Select Resolution under the title "Select Bill Type". You will have to use something besides IE because the onclick funtion I use doesn't work in IE. So instead of using an onclick function, I have to use a Submit button and thats where I ran into this trouble.

<cfif isdefined("form.srinput")>
<cfset s = '#houseorig#'>
<cfset r = '#billtype#'>
<cfset input4 = form.srinput>

<cfelseif isdefined("form.hrinput")>
<cfset h = '#houseorig#'>
<cfset r = '#billtype#'>
<cfset input4 = form.hrinput>

<cfelseif isdefined("form.scrinput")>
<cfset s = '#houseorig#'>
<cfset cr = '#billtype#'>
<cfset input4 = form.scrinput>

<cfelseif isdefined("form.hcrinput")>
<cfset h = '#houseorig#'>
<cfset cr = '#billtype#'>
<cfset input4 = form.hcrinput>

<cfelseif isdefined("form.sjrinput")>
<cfset s = '#houseorig#'>
<cfset jr = '#billtype#'>
<cfset input4 = form.sjrinput>

<cfelse>
<cfset h = '#houseorig#'>
<cfset jr = '#billtype#'>
<cfset input4 = form.hjrinput>
</cfif>

Paross1,
I wasn't thinking about that and you gave me a great idea. Here is how I changed my select boxes.

<cfform action="Resolution_History.cfm?year=#year#&sessiontype=#sessiontype#&btype=res" name="form">
<select name="SRINPUT">
<option value="">SR
<CFOUTPUT Query="findSR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>

<select name="HRINPUT">
<option value="">HR
<CFOUTPUT Query="findHR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>

<select name="SCRINPUT">
<option value="">SCR
<CFOUTPUT Query="findSCR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>
<br>
<select name="HCRINPUT">
<option value="">HCR
<CFOUTPUT Query="findHCR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>

<select name="SJRINPUT">
<option value="">SJR
<CFOUTPUT Query="findSJR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>

<select name="HJRINPUT">
<option value="">HJR
<CFOUTPUT Query="findHJR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
</select>

<INPUT TYPE="Submit" VALUE="Submit" alt="submit button">
</cfform>

On the action page I need the below IF statement to work so it will set the variables. It isn't working at this time. Its not bringing the values of billnumber, houseorig or the billtype.

Do you have any thoughts? I know it is close. I need to set all of the inputs to input4 to generate my queries.

<cfif form.srinput gt 0>
<cfset houseorig eq "s">
<cfset billtype eq "r">
<cfset srinput eq input4>

<cfelseif form.hrinput gt 0>
<cfset houseorig eq "h">
<cfset billtype eq "r">
<cfset hrinput eq input4>

<cfelseif form.scrinput gt 0>
<cfset houseorig eq "sc">
<cfset billtype eq "r">
<cfset scrinput eq input4>

<cfelseif form.hcrinput gt 0>
<cfset houseorig eq "hc">
<cfset billtype eq "r">
<cfset hcrinput eq input4>

<cfelseif form.sjrinput gt 0>
<cfset houseorig eq "sj">
<cfset billtype eq "r">
<cfset sjrinput eq input4>

<cfelse>
<cfset houseorig eq "hj">
<cfset billtype eq "r">
<cfset hjrinput eq input4>
</cfif>

Below is the code that I am trying to use. The first select box I need to pass the Input4, S, R all as separate variables. The second select box I need to pass Input4, H, R all as separate variables. Input4 are all numbers and I need to make each number distinct by adding the S, R or the H, R. I used an onclick function when I first created this page but I later found out it doesn't work in Internet Explorer. It worked great in other browsers though.


<cfform action="Resolution_History.cfm?btype=res" name="form">
<select name="INPUT4">
<option value="">SR
<CFOUTPUT Query="findSR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
<input type="Hidden" name="houseorig" value="s">
<input type="Hidden" name="billtype" value="r">

</select>

<select name="INPUT4">
<option value="">HR
<CFOUTPUT Query="findHR"><Option Value="#BILLNUMBER#">#BILLNUMBER#</cfoutput>
<input type="Hidden" name="houseorig" value="h">
<input type="Hidden" name="billtype" value="r">
</select>

<input type="Hidden" name="year" value="<cfoutput>#year#</cfoutput>">
<input type="Hidden" name="sessiontype" value="<cfoutput>#sessiontype#</cfoutput>">

<INPUT TYPE="Submit" VALUE="Submit" alt="submit button">
</cfform>

Yes, it's possible. Post your code.

The NAME that you use for each SELECT tag will be the FORM variable name on the action page to which you submit.

Phil