Implement
<cffunction name="onRequest">
<cfargument name = "targetPage" type="String"
required=true/>
<cfsavecontent variable="content">
<cfinclude template="#Arguments.targetPage#">
</cfsavecontent>
<cfoutput>#content#</cfoutput> <!---
requested page content --->
</cffunction>
You can then change gear in onRequestStart with:
<cfset dsn = application.dsn>
In fact, you can forget about application.dsn and do the
following in onRequestStart:
<cfset dsn = "myDSN">