Hi,
I managed to 'rebuild' sample 11 Dependent Combo boxes.
Also storing the selected values into sessions vars.
After submitting the form its redirecting to an other page (showing sql query based on session vars just set).
So far so Good !!!

But, when selecting the form again, i want to:
- Set the default question based on the session  vars (=latest  selections)
AND
- Fill the comboxes and keep values selectable

I tried but cannot get it working some how.
I came close with a 'workaround'  but then I need an extra (unwanted) question.
http://nbbv.nl/Form2/tabid/221/Default.aspx
Is what I want possible anyway?

Thanks, Rob

Rob,

Hi. Well we have had to come up with a solution for this as a few other clients are running into the same hurdles. Basically, until the form renders (because of how the form is generated and at the time the form is generated) it cannot get access to the current values until after postback. This is 'why' your post back solution posted there where they click that first field does end up working properly, where it doesn't before the postback.

So... The solution we implemented because of this was to also parse the SQL for a number of querystring or session variables. These are:

Querystring Variables:
* DSParam1
* DSParam2
* DSParam3

Session Variables:

* DSSession1
* DSSession2
* DSSession3

So this solution works if you use these (pass these session or querystring variables) it will render properly. Basically you just would need to name your short field name DSSession1 and pass the form that session variable.

The other item to note here is : Be careful with querystring variables to avoid SQL Injection. We have posted this several times but the bottom line is that we always suggest using caution with querystring variables and SQL Options etc... The best approach is to use a stored procedure and pass the querystring variable to the procedure. The module does handle some SQL injection routines but again, always better to be safe and cautious. You probably are safer with the session variable implementation than querystring.

The enhancements mentioned above (for the querystring and session variables) should be ready by the end of the week and will be in a patch of 2.6.54 which includes a few minor enhancements and bug fixes. This should be posted on Snowcovered by June 1st.


-Chad