I have a question. I have the following script for my page:
<!--- store the selected Main_Group variable variable
after the first select boxes submits itself --->
<cfif isDefined('form.select_Main_Group')>
<cfset page.select_Main_Group =
form.select_Main_Group>
</cfif>
<cfoutput>
<form name="DropDown" method="post">
<!--- query DB for the first drop down list --->
<cfquery name="get_Main_Group" datasource="ds">
SELECT group_id, group_name
FROM tblGroups
</cfquery>
<!--- first drop down list --->
<!--- NOTICE the onChange javascript event in the select
tag, this is what submits the form after the first selection
--->
<select name="select_Main_Group" required="yes"
onchange="this.form.submit()">
<option>Select Main Group</option>
<!--- dynamically populate the first drop down list based
on the get_Main_Group query --->
<!--- NOTICE the CFIF within the option tag, this says,
if the first selection has been made, display the chosen option
when the page reloads --->
<cfloop query="get_Main_Group">
<option value="#group_id#" <cfif
isDefined('form.select_Main_Group')><cfif
form.select_Main_Group eq
"#group_id#">selected</cfif></cfif>>#group_name#</option>
</cfloop>
</select>
<p>
<!--- if the first selection has been made, display the
second drop down list with the appropriate results --->
<cfif isDefined('page.select_Main_Group')>
<!--- query DB for second drop down list, based on the
selected item from the first list --->
<cfquery name="get_Sub_Group" datasource="ds">
SELECT group_id, subgroup_id, subgroup_name
FROM tblGroups
WHERE group_id = #page.select_Main_Group#
</cfquery>
<!--- second drop down list --->
<select name="select_Sub_Group" required="yes">
<option>Select Subgroup</option>
<!--- dynamically populate the second drop down list
based on the get_Sub_Group query --->
<cfloop query="get_Sub_Group">
<option
value="#subgroup_id#">#subgroup_name#</option>
</cfloop>
</select>
</cfif>
</form>
</cfoutput>
I am using onchange="this.form.submit()" but I don't want to
submit the form. I tried using the onchange event but the values
were not passing through. Can someone please help me.
Thank you,
Sevor Klu