Hi Chad & Datasprings.

Just purchased Dynamic Registration & the Opt in email modules, they are excellent!

Question that I have not figured out yet:

Q: I want to add a drop down from which COUNTRY my visitors are from. How do I add this from the DNN core and tie it together with a Dynamic Registration Field?

Thanks...

I think the SQL should be like this for country:

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'

If you use Region it will return States etc.

Question:  How can I use the ComboBox to show the list of Country and Regions?  That way it only takes up one line on screen.

This is good, but how to I set the default to the United States? I tried entering United States in the Default field; that didn't work.

Thanks.

Actually, i got that to work with out-of-the-box Dynamic Registration functionality. I didn't explain well. I am getting State and Country from a Session variable and I want State and Country to default to the one provided in the session variable unless there isn't one. But if it's not the right State or Country (or Province or Region) then I want the user to select the correct one from the list of Region and Country. Can you solve this one? LOL

Hmm I would stay away from session variables if possible but I guess that not the case here.

I could think of a way if we could write a sproc and pass the session variable to it...

I removed all of the countries other than Canada and United states, then used the query

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country' order by QuestionOptionValue DESC

You _could_ have modified the List table contents to use a Sort Order, then set the Order By clause to use the Sort Order column