Hello Cynthina,
To get SQL Binding to work with a Dynamic Form, all columns that are returned must share the exact name as the short field name of the respective questions on your form.
If you return a column in SQL Binding named "FullName", then you'll need to have a Question on your Form with the shortfield name of "FullName".
Also SQL Binding only accepts the following variables: $(DSParam1), $(DSParam2), $(DSParam3), $(DSSession1), $(DSSession2), and $(DSSession3)
If you try to use any other tokens, the SQL Bind will not work as expected.
So you'll want to have a hidden field on your form with the following:
* Lowest sort order of all Questions
* Shortfield name of "DSParam1", "DSParam2", "DSParam3", "DSSession1", "DSSession2", or "DSSession3"
* Enable Retrieve value from Querystring variable if using: DSParam1, DSParam2, or DSParam3
* Enable Retrieve value from Session variable if using: DSSession1, DSSession2, or DSSession3.
Note, that he SQL bind will attempt to fire every page load whether the querystring variable / session variable is present or not.
To keep SQL Binding from firing all the time you should look into the "Only enable when Querystring value is Present" feature of SQL Binding(Page 154 of the User Guide):
http://www.datasprings.com/userguid...rGuide.pdf Let me know if you have any questions.
Thanks,
Ryan