Welcome to CF David! Ideally you never want to output data in your CFC
functions. The best approach is to input arguments into the function and then
return data to be displayed. Here is an example I am working on right now. Hope
it helps:
<cffunction name="GetSubscriberInformation" access="public" returnType="query">
<cfargument name="div_id" type="numeric" required="true" />
<cfargument name="acc_num" type="string" required="true" />
<cfset var loc = structnew() />
<cfstoredproc procedure="schema_name.getSubscriberInformation"
datasource="test">
<cfprocparam type="in" value="#arguments.div_id#"
cfsqltype="CF_SQL_NUMERIC" />
<cfprocparam type="in" value="#arguments.acc_num#"
cfsqltype="CF_SQL_VARCHAR" />
<cfprocresult name="loc.query_data">
</cfstoredproc>
<cfreturn loc.query_data />
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322281
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
