Hi Sebastian and all

This is a recurring (and old) question, then I'll post step-by-step the problem and how to solve it:

1 - Go to Host > Lists
a - Like USA and Canada lists, create a new list Region for your country and put some states in this list;
b - example: Country.Brasil:Region with entries Acre/AC, Amapá/AP, Amazonas/AM, etc...

2 - Go to your profile page and edit
a - change the country for Albania;
b - note that the Region field is a textbox;
c - change the country for USA or Canada;
d - note that the Region field is now a drop-down list, filled with regions from lists;
e - now switch to your country (Brasil) and see that the field Region back to be a textbox, even having a list of regions like USA and Canada.

Let's see how to solve this problem:

3 - Go to Host > SQL
a - type the following query to list the entries in the table Lists:

Select * From Lists

b - uncheck 'Run as script' and click 'Execute';
c - locate the entries with the regions of your country, and note the values of field EntryID.
Also note that the column SystemList regions of the USA and Canada are checked boxes, and regions that you included are UNchecked boxes;
d - suppose the 3 regions included have the EntryID value as 419, 420 and 421;
e - update the SystemList field with the value 1 for each region, using the following statment SQL:

Update Lists Set SystemList = 1 Where EntryID = 419

f - CHECK 'Run as script' and click 'Execute';
g - repeat this Update-Execute for each entry;

Update Lists Set SystemList = 1 Where EntryID = 420
(click 'Execute')
Update Lists Set SystemList = 1 Where EntryID = 421
(click 'Execute')

And done! =D
Now, go back to the edit page of your profile and switch between countries with and without regions and see that when your country is selected the field Region finally turns a drop-down list!

PS: I know that the update command can be better written, I put this way purposefully not to complicate for those who aren't programmers.

PS 2: I'll put in Gemini the problem and solution. and I think in module lists should exist more fields accompany each entry, as a box to set the entry is part of a list of the system, for example.

Hugs

---

Comunidade BrasilDNN Marcio Maciel, Brasil

Hi Sebastian

Yes I know. I was already planning to make several SQL to automate the process of ' becoming more Brazilian ' each new DNN I install, but in this case I was wondering why my list does not work as expected equal lists USA/Canada.

And to think that all this work is due to a true/false field!

=]

Hugs

---

Comunidade BrasilDNN Marcio Maciel, Brasil