problem CF6 Read data DB e Dropdown

I can not recall the data in a column of the table
table: clex_area
collum: nome_area

[attachment=73076_20171213140301_db-jpg.jpg][/attachment]

The result is that:
[attachment=73076_20171213140325_resoult-jpg.jpg][/attachment]

The menu’s dropdown configuration is that:
[attachment=73076_20171213140955_configuration-dropdown-menu-jpg.jpg][/attachment]

and
The "setup" ->read data configuration is that:
[attachment=73076_20171213141331_configuration-setup-menu-jpg.jpg][/attachment]

I read everywhere, trying to understand where i’m wrong. Can you please help me to resolve this problem? 😶🙄

up

Hi thesamu ,

I can't fully understand what you are trying to do here :-(

I did notice that in "Richiamo' you have selected the Select Type "Return an array of key/value pairs, two fields must be provided" BUT in the retrieved fields box you only have one field.

Bob

Hi Bob, thanks for the reply!

I think I did everything wrong !! 😢
What should I do to recall the data in the "area_name" column of a "clex_area" table in the dropdown menu?

Hi thesamu,

Please spell out exactly what you need to do.

Is this a drop-down you are building when the form is loaded? If so what are the key-value pairs that you want to set? It looks as though nome_area may not be unique so you can't use that as a key.

Bob

I solved, it was a position problem of the read_data module