Chaining select lists
Hi,
I try to create two dynamic depending selectlists whereas the second select list depends on the choose of the first list.
Both lists are populated by a database query.
Here is a simple example:
First list: Usergroups
<cfselect name="usergroups" >
<cflloop query="select_usergroup">
<option value="id">#usergroup_name#
</cfselect>
Second list: Users
<cfselect name="users" >
<cflloop query="select_user">
<option value="id">#user_name#
</cfselect>
When selecting a usergroup in the first list, the query of the second list runs in dependence of the value of first list.
Is there a possibility to solve this problem without using Url-parameter? I have a big formular with many form-fields and I assume that this method is not very fast.
I also try to use data binding, but then I have a problem preselecting values in the lists.
Environment: Oracle 11g, ColdFusion 9 Standard
Any idea?
regards Claudia
