SQL snippet to Fill US state DropDownBox in Dynamic Forum (DNN)


Here is the code Snippet:

SELECT QuestionOption, QuestionOptionValue

FROM (SELECT ‘– Select –‘ AS QuestionOption, ‘-1’ AS QuestionOptionValue

UNION ALL

SELECT  TEXT AS QuestionOption, VALUE AS QuestionOptionValue FROM Lists WHERE ListName = ‘Region’ AND ParentID = (SELECT EntryID FROM Lists WHERE VALUE = ‘US’)) AS alias

ORDER BY QuestionOption

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s