0 Replies Latest reply on Sep 14, 2007 2:56 PM by

    JSON  with CFSELECT problem or data type

      First let me say this, CF8's AJAX looks impressive. However, I'm not having a good time after initial quick testing success.
      Here's the problem.
      Back end: Access database, the particular field named gender use data type of "number".

      CFC, component named myTest.cfm, function has this
      <cffunction name="getGender" access="remote" returntype="array">
      define a var for data storage
      run a query
      append result to the defined array
      return the array

      Calling CF template looks like this
      <cfselect name="gender"
      bind="cfc:myTest.getGender()"/>

      Execution result, the select element is Empty.

      Debugging/testing:
      <cfinvoke component="myTest"
      method="getGender"
      returnVariable = "myTest">
      <cfoutput>#myTest#</cfoutput>
      TESTING RESULT=1.0
      which suggests that the delimiters using the Array is "." (dot), so, maybe, by default the CFSELET is expecting delimiters of "," or ";". What do you think? How may I circumvent it? I've also tried the returntype of string for the function, but returned the same "1.0", that is, two values using the "." (dot) delimiters.

      Thank you.