Your best bet is to encapsulate all your SQL into a collection of DAOs, and have one collection for each target database. Then you have a configuration parameter that says which DB you're using, and your code then uses the appropriate collection of DAOs to do the data access.
That might seem like you'll need to write every query X times, where X is the number of target databases. For some queries, that's true, but for a lot of them, standard SQL will work. So create an abstract version of each DAO that has general query implementations in them, and then only override the ones you need to in your db-specific DAOs. It's a little more complex to implement, but it'll make you job a lot easier down the road. cheers, barneyb On Apr 11, 2005 1:07 PM, jonese <[EMAIL PROTECTED]> wrote: > Anyone have any pointers or examples of CF or PHP application which have > been constructed with the ability to work on multiple Databases? IE the > application can easily be run on MSSQL, Access, MySQL etc and all the user > has to do is changed a config variable or point to another DB file. > I'm trying to do the leg work now for a future upgrade to our CMS. Right > now it runs on MSSQL, but we want to make it so users can easily install it > into mysql, etc. > thanks in advance. > jonese > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202282 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
