Forums

How work dropdown?

ozkrsanchez 26 Sep, 2020
Hi everybody,

I need configure dropdown in my form, but i dont'n know how work.

I have a configured dropdown with two options "YES" and "NO". Any option you choose saves me in the database at a value of 1.

I have tried all the possible combinations but still it keeps me the same value.







This is the configuration in mysql.




Any idea what I have wrong?
Max_admin 26 Sep, 2020
what is shown in the form debug after the form is submitted ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ozkrsanchez 27 Sep, 2020
In the submit if it brings me the selected data.The problem is when saving to the database.



What I don't understand is because in the DB it only saves the value of 1 in all the dropdown.
GreyHead 28 Sep, 2020
Hi ozkrsanchez,

Please see this FAQ it's written for an older version of ChronoForms but the same principals apply.

Bob
Max_admin 28 Sep, 2020
please post the rest of the debug, what 's the SQL statmenet ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ozkrsanchez 28 Sep, 2020
Ok mMax, i send a example from cero.







Is complet.
Max_admin 28 Sep, 2020
this is weird, but it suggests that there is a problem with the database table settings, since the SQL looks good.

what happens when you copy the SQL and try to run it in phpmyadmin ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ozkrsanchez 28 Sep, 2020
Hi Max, i think so, but, i dont find the error!!!

Look the insert direct in P






As you can see, it keeps them the same.

Help me pls!!!
Max_admin 28 Sep, 2020
it must be a database setting, but I do not know about it, you should either ask your hosting support or post a a question on https://stackoverflow.com/
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.