MachForm Community Forums » MachForm 2

1. fredwin
   Member

   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

   Posted 16 years ago #
2. 

   yuniar

   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

   Posted 16 years ago #

RSS feed for this topic

Reply

You must log in to post.