Avatar of monica73174
monica73174

asked on 

CFSELECT Bind Failed

I have a cfselect that I am trying to bind.  I placed the cfc in a folder beneath the directory where the cfselect code is.  I keep getting this error:bind: Bind failed for select box clients, bind value is not a 2D array or valid serialized query.  I cannot seem to find an answer for this problem.  
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>

Open in new window

Web Servers

Avatar of undefined
Last Comment
monica73174

8/22/2022 - Mon