OK, this is kinda dumb, but I need a think break .
Some acquaintances and I have been having a discussion on database inputs. I'm partial to using HTML select items for miscellany that, while important to the database app, do not have to be in a table.
For instance, if I'm listing a series of options, particularly if there can be multiple choice, I'll create a select with the available choices with binary values, e.g., 1, 2, 4, 8, 16, 32, ... . They are hard-coded into the appropriate page/form, and it's easy to make additions when required.
The quarrel is that this data is not truly in the database until a value is selected, thus there is no source for it. I can appreciate the concept, but at the same time, no call to the database is required to populate the appropriate select(s).
This discussion has been going on for a couple of months - the group involved is, while small, global - and some good points have been made on both sides of the issue. I suspect this is one of those discussions that no one wants to win, but everyone seems to have a [rather fervent] opinion.
Given that, I'm curious what the folk here might think - and why - one way or the other. (And, if you happen to be one of the group (yeah, I know, I just branded myself), please abstain from comment - this is a search for outside opinions .)