I see where you are coming from but honestly, it's a matter of course - I do not like it, but it is not "bad database design"; it may not be everyone's idea of good design but there could be valid reasons to do so.
Using lists within a DB design does not break any DB design "rules" i.e. industry standard. There are many tricks that we all use which may be regarded as bad design - plularised table tables, int datatypes when tinyint should be used, underscores in table or column names - all of which (depending on who you speak to) are bad designs. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 07 December 2005 11:52 To: CF-Talk Subject: RE: SQL Question. Compare one list to another > It is not ideal; but it is not bad design pe se - there my be > reasons to store them in this manner in some design cases. No, actually, that is a textbook example of bad database design. While you may have reasons for doing this - I can't think of any offhand, but who knows? - it would still be bad purely according to the fundamental tenets of relational database design. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
