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:327652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
