Yes and as I tried to point out in my other email. My experience is that a lot of the developers at work have no idea on how to deal with cross tables or even what one is. They end up defaulting to doing this list in a database column and then reverting to CFM to make a search possible. I end up seeing massive amounts of CFM in pages to handle what could have easily been done via a cross table. If they were used to always doing things with cross tables they would not run into this problem. I can not think of an example where something would not work or need massive amounts of CFM to work if they were doing the list in a column.
As one of the leads in a CFM group, I personally would rather see cross tables always used instead of never used. Of course I also would rather see people know when to use a cross table and when to use a list in a DB column, but that seems to be asking for too much. Guess that is the problem in only some work areas and I unfortunatly am in one of those areas. On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>Such as wanting to see all users who have full rights to modify that > properties table. > > Again, if you DO need this, then go by the book. > My point is that you don't always need this, and if you don't need it, > do not bother with cross table. > So it is not true that it is always better with cross tables. > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235701 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54