Hi. I must be doing something wrong. I am using Dynamic User Directory and Dynamic Registration (integrated with DNN profile).

I want a combo box that lets me search by City (one of the fields).

I used Manage Search with

FieldName	City
Criteria	contains
InputSQL	Select Text as SearchOption, Text as SearchOptionValue from Lists Where ListName = 'City'

I get a blank Combo box.

Suggestions?

Rob

Hi. If you go to Host, SQL does this same query work there? Its possible your site uses object qualifiers and your tablename isn't lists. Maybe its something like dnn_lists?

-Chad