"Adam Cameron" wrote >> We have database abstraction CFC... They handle the differences between MS-SQL, >> Oracle, MySQL and what-have-you, as well as removing the need to know *how* we're >> doing stuff under the hood.
>> Each DB table has a CFC that relates to it, and might have methods like get(), >> add(), update(), delete(). The get() function will take an argument for each field >> of the table, to allow filtering (basically chucking it in a where statement), as >> well as an additional 'whereClause' argument for stuff that ain't a direct >> col=value filter. <<<<<<<<<<<<<<<>>>>>>>>>>>>>>> This sounds interesting. We're looking at ways to swap out the underlying db for another vendor (from Informix to SQLServer and/or MySQL) per site deployment. So far the best we can do is have lots of persist.cfc's that contain all the SQL. At least it's all in one spot. I've been re-visiting FourQ within Farcry (is FourQ a daemon.com.au thing or a Spectra idea?) to see if that can help. >> Each DB table has a CFC that relates to it That's a bit hard for us to do. 140+ tables = 140+ CFC's just for data access. We also have the added complication that there's a lot of conditional logic to build either the SQL or the result sets - things that should be in joins (or in the T-SQL for SQLServer) but are wrapped up in a legacy db design (no varchars!). eg: query for person, address in tableA if (query for person in tableB) get tableB.address address = tableB.address end if if (query for person in tableC) get tableC.address address = tableC.address end if return person, address so what I'm curious about are ideas that would allow us to use diff db's without resorting to re-writing nearly 2000 queries for each db vendor. any suggestions? thanx barry.b -- _______________________________________________ Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! http://www.net2phone.com/cgi-bin/link.cgi?143 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
