rendered paste body<!--- test.cfc --->
<cfcomponent>
<cffunction name="GetSprocs">
<cfstoredproc procedure="sp_schedule" datasource="mysqltesting">
<cfprocresult name="Schedule" ResultSet="1">
<cfprocresult name="Tasks" ResultSet="2">
<cfprocresult name="Frequency" ResultSet="3">
</cfstoredproc>
<cfreturn Schedule>
</cffunction>
<cffunction name="SetVars">
<cfset PageTitle="Schedule">
<cfreturn PageTitle>
</cffunction>
<cffunction name="IncludeTemplates">
<cfargument name="schedule" type="query" required="true">
<cfset PageTitle="Schedule">
<cfinclude template="HTML/ShowHeader.cfm">
<cfinclude template="HTML/ShowSchedule.cfm">
<cfinclude template="HTML/ShowTask.cfm">
<cfinclude template="HTML/ShowFrequency.cfm">
<cfinclude template="HTML/ShowFooter.cfm">
</cffunction>
</cfcomponent>
<!--- test.cfm --->
<cfinvoke component="test" method="GetSprocs">
<cfdump var="#Schedule#">
<!---
<cfinvoke component="test" method="SetVars">
<cfinvoke component="test" method="IncludeTemplates" type="query" arguments.schedule="schedule">
--->
<cfset PageTitle="Schedule">
<cfinclude template="HTML/ShowHeader.cfm">
<cfinclude template="HTML/ShowSchedule.cfm">
<cfinclude template="HTML/ShowTask.cfm">
<cfinclude template="HTML/ShowFrequency.cfm">
<cfinclude template="HTML/ShowFooter.cfm">