> 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 table. It takes me less than five minutes to write the logic within a page that updates multiple records. I can't imagine it would take you any longer. Therefore, the time you're saving with your shortcut is negligible. > For instance, if you need to store in an employee table which > days in the week he is ok to work, will you create a table > with the 7 days in the week and a cross table between the > employees and the days? > SURE, just in case some one decides to make an eigth day in > the week, who knows! This example has a couple of characteristics that are clearly identifiable; if you wanted to say that, in the case where you have those characteristics you might take an alternate approach, that's fine. In this specific case, you have a fixed list of Boolean values. But you don't say that, you simply say "take shortcuts" instead of "when you have a fixed list of Boolean values, you can store that within a single field of your existing table". And, in this case, you still wouldn't want to store this as a list, because that's more complicated than necessary. You'd simply use bit fields within your table. Now, that's not a shortcut, it's the proper way to handle a fixed list of Boolean values. So, in summary, your shortcut sucks. > This is ridiculous. ;-) Yes, it is. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
