<cfcomponent>
	<cffunction name="sayHellow" access="remote" returntype="String">
    	<cfargument name="firstname" type="string" required="yes">
        <cfargument name="lastname" type="string" required="yes">
		<cfreturn "#firstname# #lastname# 您好 ! 這是你的 sayHellow 方法">
	</cffunction>
 
    <cffunction name="getCustomer" access="remote" returntype="query">
    	<cfquery name="customerQuery" datasource="finpo">
        	select *
            from customer
        </cfquery>
		<cfreturn customerQuery>
	</cffunction>
</cfcomponent>

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical"
	 fontSize="16">
	<mx:Script>
		<![CDATA[
			import mx.rpc.events.ResultEvent;
 
			private function clickHandler():void{
				this.roDB.getCustomer();
			}
 
			private function resultHandler(event:ResultEvent):void{
				this.customerResultData.dataProvider = event.result ;
			}
		]]>
	</mx:Script>
	<mx:Button label="查詢資料" click="clickHandler()"/>
	<mx:DataGrid id="customerResultData">
		<mx:columns>
			<mx:DataGridColumn headerText="客戶編號" dataField="cust_id"/>
			<mx:DataGridColumn headerText="客戶名稱" dataField="cust_company_name"/>
			<mx:DataGridColumn headerText="客戶地址" dataField="cust_company_addr"/>
		</mx:columns>
	</mx:DataGrid>
	<mx:RemoteObject id="roDB" destination="ColdFusion" source="comp.helloworld" result="resultHandler(event)"/>
</mx:Application>