SQL Driven Check Box - Data Springs Inc. - DotNetNuke Modules - DotNetNuke Module Product Forums - Product Discussion - DotNetNuke Modules - Dynamic Forms

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms

SQL Driven Check Box

Last Post 01-13-2010 08:12 AM by David To. 3 Replies.

Author

Messages

dyn010

User is Offline

wading in the water

wading in the water
Posts:23
Avatar

01-11-2010 01:13 PM
Can I use a session variable or query string variable passed in the SQL Driven Option of a combo box to populate the combo box i.e. I would like to pass the city from the first form and use it to get the checkbox options on the second form using the SQL Driven area?

David To

User is Offline

river guide

river guide
Posts:2719
Avatar

01-12-2010 06:35 AM
HI, if you name the city shortname with DSParam1, DSParam2 or DSParam3 you could pass these as query string variables and in your second form, your SQL driven option would be: select * from tablename where columnname = '$(DSParam1)' This would retrieve all row data with a column matching what a user picked from first form city field. Is this what you are trying to achieve? Or are you trying to populate the checkbox group with a dynamic SQL statement based on which "City" is picked from the first form? -- David

dyn010

User is Offline

wading in the water

wading in the water
Posts:23
Avatar

01-12-2010 06:59 AM
I am trying to populate the checkbox group with a dynamic SQL statement based on which "City" is picked from the first form - does that work the same way as your note above? -- Thanks

David To

User is Offline

river guide

river guide
Posts:2719
Avatar

01-13-2010 08:12 AM
HI, yes I believe it will work the same way. -- David

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms

T�rk�e dublaj film

baglan film izle