Skip to content

Dynamic Forms: Combo Box SQL Query for U.S. States Only

by on January 5, 2010

To create a dropdown list using SQL query that pulls from DNN’s Host > Lists using the U.S. Region sublist:

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Region' and ParentID = '221'
Advertisements
Leave a Comment

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

%d bloggers like this: