>>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
updating a multi records cross table.
3º you don't need a joined table in the query, just one table;
4º you don't need a query each time you want to check if an item has a
certain property,
you just check for the property in a list, which you can even store
in a session variable.
5º only beginners go by the bible, experienced programmers know short cuts.
6º bibles are made for beginners;
7º beginners are supposed to learn from experience, if they keep on
going by the bible,
and don't experiment, they will remain beginners...
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 is ridiculous. ;-)
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:257670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
