You should also definitely evaluate the ORM capabilities in CF9. They may or may not solve 100% of your problem, but it's certain to go a long way towards a solution regardless.
-Cameron On Sat, Oct 24, 2009 at 7:18 PM, Ramon Ecung <[email protected]> wrote: > > Just curious how others handle making their programs capable of being run on > multiple databases. I'm currently running Oracle XE and MySQL and I want to > develop my next application for both databases mainly for the experience, but > also so I can learn more about the differences between MySQL and Oracle. > > My main thought on this was to create two functions in my cfc for every > where/transaction I need (one for Oracle, one for MySQL) and just have a > variable in my allplication.cfc that tells the code which function to call. > > Is this the best way? Does anyone else have experience doing something like > this? > > -Ramon Ecung II > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
