asked on
here is the cfm file.
<cfform>
<cfselect name="client" id="clients" bind="clients.getClients()" bindonload="true" display="CLIENT_NAME" value="CLIENT_ID">
</cfselect>
</cfform>
Here is the CFC File ---------------------------------------------------------------------------------------
<cfcomponent>
<cffunction name="getClients" access="remote" returntype="array">
<!--- Define variables --->
<cfset var data="">
<cfset var result=ArrayNew(2)>
<cfset var i=0>
<cfquery datasource="#session.client_storage#" name="data">
SELECT CLIENT_ID, CLIENT_NAME, EMAIL_OPT_OUT
FROM CLIENT
</cfquery>
<cfloop index="i" from="1" to="#data.RecordCount#">
<cfset result[i][1]=data.CLIENT_ID[i]>
<cfset result[i][2]=data.CLIENT_NAME[i]>
</cfloop>
<cfoutput>#arrayLen(result)#</cfoutput>
<cfreturn result>
</cffunction>
<cffunction name="getOptOut" access="remote" returntype="numeric">
<cfargument name="CLIENT_ID" required="yes">
<cfset var optOut = "">
<cfquery datasource="#session.client_storage#" name="data">
SELECT EMAIL_OPT_OUT
FROM CLIENT
WHERE CLIENT_ID = #ARGUMENTS.CLIENT_ID#
</cfquery>
</cffunction>
</cfcomponent>