JSON object error

guys, I am getting following error when i access a CFC from Bind attribute of CFSELECT- "Bind failed for select box,bind value is not a 2 D array or valid serialized query." Here is my component: _________________________________ <cfcomponent>     <cffunction name="rptData" access="remote" returntype="string" returnFormat="JSON" output="yes">>       <cfargument name="idVal" type="numeric" required="yes">         <cfquery name="rptName" datasource="advrpt">         select REPORT_NAME from advance.entity t         where t.ID_NUMBER < <cfqueryparam cfsqltype="cf_sql_varchar" value="#idVal#">         </cfquery>         <cfset jsonObj=#SerializeJSON(rptName)#>         <cfreturn jsonObj/>     </cffunction> </cfcomponent> _________________________________

Is the server call erroring?  Use FireBug or MS Fiddler to capture the actual ajax request and confirm the status code and response body. ~Brad guys, I am getting following error when i access a CFC from Bind attribute of CFSELECT- "Bind failed for select box,bind value is not a 2 D array or valid serialized query."

When I use "http://127.0.0.1:8500/prototype/getData.cfc?method=rptData&idval=0000000004" in URL, I get following displayed in browser- "{\"COLUMNS\":[\"REPORT_NAME\"],\"DATA\":[[\"AAA\"],[\"BBB\"]]}" Looks like the JSON object is properly get created. Then not sure whats wrong

Hello, you should return it as 'plain', and not as json (it 'double jsonencode' it then) > When I use "http://127.0.0.1:8500/prototype/getData. > cfc?method=rptData&idval=0000000004" in URL, I get following displayed > in browser- > "{\"COLUMNS\":[\"REPORT_NAME\"],\"DATA\":[[\"AAA\"],[\"BBB\"]]}" > > Looks like the JSON object is properly get created. Then not sure > whats wrong

I think you are double encoding your JSON.  You don't need to put returnFormat="JSON" in the component definition AND use the SerializeJSON() function.  Pick one.  Your CFC is returning JSON- but it is a JSON representation of a string that also just so happens to be a JSON representation of your result set. ~Brad When I use "http://127.0.0.1:8500/prototype/getData.cfc?method=rptData&idval=0000000004" in URL, I get following displayed in browser- "{\"COLUMNS\":[\"REPORT_NAME\"],\"DATA\":[[\"AAA\"],[\"BBB\"]]}" Looks like the JSON object is properly get created. Then not sure whats wrong

Big thanks to Brad and Stephane. It did work properly now once I set format as "Plain".