WXLive Webinar #107
Friday March 7 2014 5:30am Pacific
Uncle Pete's Corner - Session 25
Storing List of Values
As Comma Separated List in One Field
Uncle Pete Halsted
A lot of the systems I work on require some type of dynamic end user configurable screen. On a recent project the end users could setup a list of “groups” that a subject could belong to. And for each of these groups they needed to be able to specify a list of valid values for that group. For instance a Group called Sex, with valid values of Male and Female. Another example is Age Range with valid values of Child, Preteen, Teen, 21-35, 36-45, 46-55, 55+.
There is a lot of ways to design the structure for this:
- Two database tables, (Group and a Child Table called Group Values)
- Store an array in the database
- One database table, with a field that contains the list of values.
For this project I chose Option 3, and we stored the values as a comma separated list in a string field. This week we will look at why I chose #3, the user interface and code for entering and storing the values, as well as the eventual dynamic screen that this configuration sets up.
Please join us by clicking the link below.
Enter as a Guest with your FULL name.
Link to: WXLive.US Live Webinar