> > I'd actually rather brush my teeth with a chainsaw than
> > store a delimited list in a database field
>
> You see? This is unbelievable what kind of weirdness people
> can do when they go by the book ;-)
I've got to agree with Andrew here. Why bother implementing a bunch of
workarounds, et
>>Why bother implementing a bunch of
workarounds, etc, when you can just build a table and the appropriate
relationship?
C'mon, we've discussed this many times,
1º using a (small) list is not a workaround, it is a short cut.
2º updating one field in a table is much more straightforward than
upda
> 1º using a (small) list is not a workaround, it is a short cut.
Before I take short cuts, the first thing that comes to mind is, "I hope I
won't need to redo this later."
> 2º updating one field in a table is much more straightforward than
> updating a multi records cross table.
If you mean t
> 1º using a (small) list is not a workaround, it is a short cut.
Whatever you want to call it, doesn't matter to me. I find that, for me,
taking short cuts now often means longer detours later.
> 2º updating one field in a table is much more straightforward
> than updating a multi records cross
>>Before I take short cuts, the first thing that comes to mind is, "I
hope I
won't need to redo this later."
Then if you're not sure, don't do it.
>>The purpose of and RDBMS is storing data in a relational way in the first
place,
Right, when there is a relation worth to be treated as such.
>>In this specific case, you have a fixed list of Boolean values.
I said a "short list", it doesn't have to be fixed.
It can be a list of codes related to a table with codes and description,
and this table is expandable.
But you don't always need a cross table between them.
I use this for permis
> Just put the days in the list, not codes ;-))
> That will make a field with a max of what? 50 characters may be? Big
> deal! ;-)
And...? It doesn't matter which types of data you store in those lists.
How would you return a workable query? You can't, and you'd have to jump
through a bunch of
On 10/21/06, Andrew Tyrone <[EMAIL PROTECTED]> wrote:
> > Just put the days in the list, not codes ;-))
> > That will make a field with a max of what? 50 characters may be? Big
> > deal! ;-)
>
> And...? It doesn't matter which types of data you store in those lists.
> How would you return a workab
>>What if a manager would like a printout of the days of the week and which
employees are available to work on each of those days.
If I worked for a company and had a manager liable to ask anything
after a project has been designed, then of course, I would take a belt
and suspenders
and use a cr
9 matches
Mail list logo
