I'm not using DAO's, but I actually managed to get an implementation that supports concatenation, outer joins, unions and a slew of other stuff for all 4 databases with just a small collection of tags. It even supports DDL for creating the tables during installation of an application.
> 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. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202293 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
