With the following code from two cfc files, how do I pass the result from 
getAllAsStruct in CustomerGateway.cfc to exportToExcel, #arguments.data#, in 
Export.cfc?

My environment is set up for using session variables. I need to cfset 
session.exportData somewhere so that it can be called?

How do I hook them up so that the getAllAsStruct array is available as 
#arguments.data#.


Export.cfc
<cfcomponent>   
        <cffunction name="exportToExcel" access="remote" returntype="boolean" 
output="true">   
        <cfargument name="data" type="string" required="yes" default="" />  
        <cfset session.exportData = #arguments.data#> 
        <cflog text="data to be exported: #session.exportData#"/>   
        <cfreturn true> 
        </cffunction>   
        
</cfcomponent>


CustomerGateway.cfc
        <cffunction name="getAllAsStruct" output="false" access="remote" 
returntype="array">
                <cfset var qRead="">
                <cfset var aRead = []/>
                <cfset var sRead = {}/>
                
                <cfquery name="qRead" datasource="#application.dsn#">
                        select *
                        from sav_customer
                </cfquery>
                
                <cfloop query="qRead">
                        <cfset sRead = {}/>
                        <cfset sRead["__type__"] = "stardust.cfc.Contact"/>
                        <cfset sRead["id_rssd"] = qRead.id_rssd/>
                        <cfset sRead["ctct_id"] = qRead.ctct_id/>
                        <cfset sRead["ser_id"] = qRead.ser_id/>
                        <cfset sRead["inst_nm"] = qRead.inst_nm/>               
        
                        <cfset sRead["ctct_fst_nm"] = qRead.ctct_fst_nm/>
                        <cfset sRead["ctct_lst_nm"] = qRead.ctct_lst_nm/>
                        <cfset sRead["updt_dt"] = qRead.updt_dt/>
                        <cfset arrayAppend(aRead, sRead)/>
                </cfloop>

                <cfreturn aRead>                
        </cffunction>

I am learning yet...


Thank you for your help.
Faye Larson 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340575
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to