This kinda ties into a recent thread on what components are (cfc's - i.e. web services) and why one should use them.
By moving to a "Service Oriented Architecture", one separates and isolates their "Data Access Objects" into single generic methods that pull the data from wherever - perhaps apply some midpoint business process - and format the data into some universal structure for applications to digest (be they web servers, flex apps or iphones). Only one place holds the (SQL) code to make "that same query" for everyone, to oversimplify... Once you have SODA and ado's, you only have one place to revise your "database speak" when sea changes like this start rolling in. Alan K Holden effects wrote: (snipped) > It's the thousands of lines of SQL > written into working apps that become useless and have to be rewritten > using a completely different paradigm. -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
