Forums

Database to DropDown not working

cyberrock 31 Jan, 2017
Hi Bob,
I have a drop down box in a form which is pre-filled from a database.
I have entered {com.PaymentPreference} in "selected Values".
According to the database it has "3" entered in the "PaymentPreference"

Options:
=
0=PayPal/Credit Card
1=CC/Cash on Delivery
2=CC/Cash on Pickup
3=Account

But 0 is always selected and not "3" as per the database.

Any ideas?

Thanks in advance
Ben
cyberrock 31 Jan, 2017
CORRECTION Database to DropDown NOT working
Max_admin 31 Jan, 2017
Hi Ben,

Which product is this ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
GreyHead 31 Jan, 2017
Hi cyberrock,

Please leave the selected values box empty.

if the name of your drop-down is com['PaymentPreference'] then the value should be automatically set from the loaded data.

Bob

PS Please also remove the first = line from the options box - if you want to set an 'Empty Option' text please use the Empty Option box.
This topic is locked and no more replies can be posted.