Well, this sounds like a good way to keep money rolling in, but a bad way to do code. It's much faster for me to write a simple join statement in a query than it is for me to deal with writing the most effecient code for extracting a value from a list - let alone trying to update said list. What happens when the permissions change? You bring everything back to CF, then you loop through the list, change/delete stuff, then re-insert the list? Or, do you write stored procedures to do this in the DB? Now, there's a good way to rack up the customer's bill.
----- Original Message ----- From: "Claude Schneegans" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, February 25, 2005 1:08 PM Subject: Re: sql question > Then, if it is to the extend that a join table becomes more efficient, it > will be time to modify it and the customer who has new specs will pay for > the necessary development. > At the time a project is developped, it is not fair to have the customer > pay for a more general and less efficient design than requested, and it is > not good practice either if you the developper spend more time doing it > this way at no charge. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196618 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