• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

OnChange()

Explorer ,
Jun 19, 2008 Jun 19, 2008

Copy link to clipboard

Copied

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
TOPICS
Advanced techniques

Views

353

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 19, 2008 Jun 19, 2008

Copy link to clipboard

Copied

LATEST
Sounds like you are trying to implement a concept called Related Selects. I did it once, like this http://www.pathcom.com/~bracuk/code/RelatedSelects.htm

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation