I can think of times needing to know all users who have permissions to do XYZ. Such as wanting to see all users who have full rights to modify that properties table. I used Properties and Product Segments because that is what the page I have opened right now is doing.
I can also think of times co-workers have taken this approach of lists in a DB column then later on realized they need to search on those items. After the fact they find themselves having to pull all records then do loops in CF looking for what they need, probably because out production DB access is so limited and they fear sending an script to the data center to modify things into cross tables after the fact. Guess when I see that happen more than once in any given quarter I can not help but wonder why not just put things into cross tables always and if you have a hard time dealing with data then get someone to write some custom DB functions to help them with it. Best I can tell the whole reason they put them in the DB as a list is because they do not know how to parse a list from a form into separate results and then insert them into a cross table. Whole reason I have my functions is because I am limited by the RAD tool used at one job, so I have to trick it via the results from a query. On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>If I want to find all properties that have ABC product segment > and I stored my product segments as a comma seperated list in my table > then > I would have a decently hard time looking for this. > > Then, if you really need this, then its probabilly better to use a cross > table. > We were just talking about user permissions as an example you may not > need it. > > -- > _______________________________________ > 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:235697 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
