Ajax Proxy Error
I need help on this error
window:global: Uncaught SyntaxError: parseJSON (http://localhost/CFIDE/scripts/ajax/package/cfajax.js, line 803)
info:http: CFC invocation response: {"COLUMNS":["ID","PROVINCE"],"DATA":[[1.0,"Punjab"],[2.0,"KhayberPaktoonKha"],[3.0,"Sindh"],[4.0,"Baluchistan"]]} Who We Are | Site Map |Privacy Policy | Contact Us
Developed by Tayab Hussain
info:http: HTTP GET /eco/Places.cfc?method=Getprovince&returnFormat=json&argumentCollection=%7B%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=D6347871AEC0896D1D0965740EA2C089&_cf_rc=0
info:http: Invoking CFC: /eco/Places.cfc , function: Getprovince , arguments: {}
info:LogReader: LogReader initialized
info:global: Logger initialized
This occured when I tried Related select and wanted to bind Provinces with Cities
The Places.cfc code is
<cfcomponent>
<cffunction name="Getprovince" access="remote" returnType="any">
<cfquery name="Lstprovince">
SELECT Id, province
FROM province
ORDER BY id
</cfquery>
<cfreturn Lstprovince>
</cffunction>
<cffunction name="GetCity" access="remote" returnType="any">
<cfargument name="Province" type="any" required="true">
<cfif ARGUMENTS.Province EQ "">
<cfelse>
<cfquery name="LstCity">
SELECT Id, province_id, desp
FROM city
WHERE province_id = #ARGUMENTS.province#
ORDER BY id
</cfquery>
</cfif>
<cfreturn LstCity>
</cffunction>
</cfcomponent>
Gettingstarted contains
<cfajaxproxy cfc="Places">
<TD>Province:<BR>
<cfselect name="SelProvince" bind="cfc:Places.Getprovince()"
display="Province" value="ID" BindOnLoad="true"/>
</TD>
<TD>City:<BR>
<cfselect name="SelCity" bind="cfc:Places.GetCity({SelProvince})"
display="desp" value="Id"/>
</TD>
Please can any body help
