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

Reply via email to