Started 3 years ago by fredwin | 2 posts |
Hi
Is there a way to change the way the data is stored in the data base for dropdowns?
That is I am using:
http://www.sqlmaestro.com/products/mysql/phpgenerator/
to create a viewable log of entries from a from, and at the moment the data comes back as a number (representing the option chosen), but I need the text name to come accross.
Hope this makes sense.
Fred
Hello Fred,
I'm afraid it won't be possible to change the way MachForm stores the values for dropdown.
MachForm uses relational tables to save database space and easy maintenance.
To be able displaying the values for your dropdown, you need to lookup into ap_element_options table too.
So you need to create a JOIN query between that table and your particular form table.
Is that tool allows you to generate the code based on query?
Some posts regarding this:
http://www.appnitro.com/forums/topic/mysql-question?replies=5
http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11
MachForm Founder
You must log in to post.
