There's also Reactor http://reactorframework.com/ Which would certainly clean
up those functions. All those case statement will make for some really big
unweildy functions.
If you didn't want to use an ORM, you could break your queries out into
seperate includes for each dbms. This makes maintanence and adding support for
other dbms's simple, it also cleans up your function so you can see whats going
on
<cffunction name"getFoo">
<cfset var dbms = getDbmsTypeFromSomewhere() />
<cfquery name="qGetFoo" datasource="whatever">
<cfinclude template="queries/#dbms#/qGetFoo.cfm" />
</cfquery>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311239
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
