Hi,
i have a mysql table (named Comuni) with all the italian city. I have to populate a dropdown control (named Citt) with the names of city.
Using a read data (read_data15) control, which values goes in 'fields to retrieve' field?
Please see also the screenshot attached.
structure of table Comuni:
CREATE TABLE IF NOT EXISTS `comuni` (
`Istat` int(6) default NULL,
`Comune` varchar(35) default NULL, ----> name of city
`Provincia` varchar(2) default NULL,
`Regione` varchar(3) default NULL,
`Prefisso` int(6) default NULL,
`CAP` varchar(5) default NULL,
`CodFisco` varchar(4) default NULL,
`Abitanti` int(7) default NULL,
`Link` varchar(38) default NULL
)
i have a mysql table (named Comuni) with all the italian city. I have to populate a dropdown control (named Citt) with the names of city.
Using a read data (read_data15) control, which values goes in 'fields to retrieve' field?
Please see also the screenshot attached.
structure of table Comuni:
CREATE TABLE IF NOT EXISTS `comuni` (
`Istat` int(6) default NULL,
`Comune` varchar(35) default NULL, ----> name of city
`Provincia` varchar(2) default NULL,
`Regione` varchar(3) default NULL,
`Prefisso` int(6) default NULL,
`CAP` varchar(5) default NULL,
`CodFisco` varchar(4) default NULL,
`Abitanti` int(7) default NULL,
`Link` varchar(38) default NULL
)
Hi Daniele,
In the "Select type" please use "Key/Value pairs" and in the fields to retreive just use "Comune"
Then use {var:read_data15} in the options box of the dropdown!
Best regards
In the "Select type" please use "Key/Value pairs" and in the fields to retreive just use "Comune"
Then use {var:read_data15} in the options box of the dropdown!
Best regards
Thank you so much! it was simple, now it works!
Dear all,
using {var:read_data15} returns a structure like {"Roma":"Roma"}.
How to get just the value "Roma" to be used sending an email?
I'm trying to get value using {var:read_data15[0]} or {var:read_data15['0']} or {var:read_data15['Comune']} but I always obtain an empty string
Please, could you help me?
using {var:read_data15} returns a structure like {"Roma":"Roma"}.
How to get just the value "Roma" to be used sending an email?
I'm trying to get value using {var:read_data15[0]} or {var:read_data15['0']} or {var:read_data15['Comune']} but I always obtain an empty string
Please, could you help me?
Hi touretteroma,
I think that you are trying to do something completely different - this thread is about reading data to populate a drop-down. You should be able to get the selected value of the drop-down using {data:input_name}
Bob
I think that you are trying to do something completely different - this thread is about reading data to populate a drop-down. You should be able to get the selected value of the drop-down using {data:input_name}
Bob
Dear Bob,
I created topic https://www.chronoengine.com/forums/posts/t105472 to better explain my case.
Regards
Tourette Roma
I created topic https://www.chronoengine.com/forums/posts/t105472 to better explain my case.
Regards
Tourette Roma
This topic is locked and no more replies can be posted.