Dependant Drop Down Boxes > Forums > Bi4ce Open Source DotNetNuke Skins: DNN Modules: DNN Consulting

Forums

Subject: Dependant Drop Down Boxes

You are not authorized to post a reply.

Author

Messages

pauldes

Posts:1392

03/01/2008 9:58 AM	Alert
This sample uses SUBQUERY and select drop downs to create a dynamic dependent drop down based on the selection made in the first drop down. It works with the DNN users and roles information in your system. The lxFetch onchange event in the first select is what triggers a refresh in the module to display the filtered list in the second select. Note: the queries in the subquery tag use aliases for the field names so that a potential conflict in field name duplication with the main listx query is avoided. You can also accomplish this with escaping, which I hate! To use, copy, paste and load the text in the XML file attached into the XML section of your ListX View Options and LOAD.
Attachment: dependentdropdown.xml
ListX....makes you look brilliant, even though you're not.

cblake

Posts:10

03/01/2008 1:49 PM	Alert
Pauldes, I've got another example here for dependent dropdowns. I'm hoping you can take a peek at it. I render the second subquery in an action variable based upon the selection in the first subquery. It seems like it is going to work for me, but for some reason the lxComboSelect does not seem to work for the subquery that gets rendered in the action variable. When the page is refreshed, I'd like to retain the values that have been selected in the dropdowns so I've assigned their respective values into session variables and use the session variable values for the lxComboSelect function. Any help you can offer is appreciated. Thanks, Chris
Attachment: config.xml

pauldes

Posts:1392

03/01/2008 4:55 PM	Alert
I don't use lxComboSelect, but if you want to retain values and have them as defaults for combo boxes in selected items, use COALESCE... selecteditems="[COALESCE,MySVar,Session,MyFVar,Form,[myfieldvalue],,MyText,Text]" This will display the first of the items in the statement that has a value.

ListX....makes you look brilliant, even though you're not.

cblake

Posts:10

03/01/2008 5:06 PM	Alert
Thanks man, I have not played with coalesce yet, but it looks like I am going to! Very much appreciate the pointer. Regards, Chris

robert_chumley
Please Wait...

Posts:595

03/03/2008 8:37 AM	Alert
Please let us know if this solves the problem. Thanks,

Robert Chumley r2integrated (formally bi4ce)

penra
Posts:15

05/20/2008 5:37 PM	Alert
This works great. In my case my initial table has multiples (the table is the state the customer resides in). The dropdown shows all of the multiples, how can I filter that?

pauldes

Posts:1392

05/20/2008 7:38 PM	Alert
are you saying you want the drop down list to only display certain values or that you want the drop down list to have a default value based on the user. What exactly does each drop down list show?

ListX....makes you look brilliant, even though you're not.

penra
Posts:15

05/21/2008 10:10 AM	Alert
Sorry I was not clear. The first dropdown box is the state, I have multiple rows for many states and all of the rows are showing in the dropdown list. I want to filter so each state only shows once. thank you!

penra
Posts:15

05/21/2008 10:12 AM	Alert
For example; AK AK AK AL AL AL AL ....ETC

svedire

Posts:107

05/21/2008 10:17 AM	Alert
Hi, Try doing a SELECT DISTINCT in your SUBQUERY. This will return all the distinct values. Thanks, Sindura R2integrated

penra
Posts:15

You are not authorized to post a reply.