How to use dynamic list on a table column? - working now

[xren]

Hi,

I am building a questionnaire form: displaying a table using repeater. Each row contains a question and it's answer (radio button choices for the answers)
I set the answer column in the table display as radio button and use a dynamic list.
In the before page script:
I fetch the table, then loop through it, for each row, I set the dynamic list query value by the question in that row.

However, the answers for all the rows are the same (the last row's answer in the database)

How can this be done?

Thanks,
Xiaoli

[Jon]

Hard to say what's wrong without looking at your form. I'm guessing that your Dynamic List has a single replaceable variable which contains your SQL statement and this is mapped to one of your table columns. Can you make sure that this variable is marked as required in the Dynamic List.

The system will try and share a Dynamic List specified for a table column - it does this to minimize the number of times the list has to be built. To stop this sharing, the list must have at least one list field marked as required that is mapped to a table column.

You might also switch on debug for the list so you can see when it is built.

Regards
Jon

[xren]

I have fixed it.

I call buildList in the loop for each row. Then it works fine now

Thank you Jon
Xiaoli