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> _________________________________ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm