0
Participant
,
/t5/coldfusion-discussions/error-parameter-validation-error-for-the-sort-function-the-function-accepts-1-parameter-s/td-p/10908486
Feb 06, 2020
Feb 06, 2020
Copy link to clipboard
Copied
I haven't modified the code in a long time, but I receive this error:
Parameter validation error for the sort function. The function accepts 1 parameter(s)
Any ideas?
Here is my code:
<cfoutput>
<CFHTTP url="http://www.zipcodeapi.com/rest/a3Pk3kJ1EvbCMrGPtI2kFH0u27u3i4heyZzsUBPv7XZDwxI0cHef4QqNOKKocXjx/radius.json/#zipradius#/#radius#/mile" method = "get" result="httpResp">
</cfhttp>
</cfoutput>
<cfset zipCodeJSON='#httpresp.filecontent#'>
<cfset zipCodeStructure=#deserializeJSON(zipCodeJSON)#>
<cfscript>
zipCodeQuery=queryNew("id,city,distance,state,zipCode","Integer,Varchar,Decimal,Varchar,Integer");
for (row=1; row lte arrayLen(zipCodeStructure.zip_codes); row=row+1)
{
rowdata=[row,zipCodeStructure.zip_codes[row].city,zipCodeStructure.zip_codes[row]. distance,zipCodeStructure.zip_codes[row].state,zipCodeStructure.zip_codes[row].zip_code];
queryAddRow(zipCodeQuery,rowdata);
}
zipCodeQuery.sort(zipCodeQuery.findColumn("distance"),true);
</cfscript>
TOPICS
Advanced techniques
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
1 Correct answer
Community Expert
,
Feb 06, 2020
Feb 06, 2020
To sort by distance, use the querySort function or query-of-a-query.
<cfscript>
sortedZipCodeQuery = querySort(zipCodeQuery, function(e1,e2){
return compare(e1.distance,e2.distance);
});
</cfscript>
<cfquery name="sortedZipCodeQuery" dbtype="query">
SELECT *
FROM zipCodeQuery
ORDER BY distance
</cfquery>
Community Expert
,
/t5/coldfusion-discussions/error-parameter-validation-error-for-the-sort-function-the-function-accepts-1-parameter-s/m-p/10908611#M184507
Feb 06, 2020
Feb 06, 2020
Copy link to clipboard
Copied
To sort by distance, use the querySort function or query-of-a-query.
<cfscript>
sortedZipCodeQuery = querySort(zipCodeQuery, function(e1,e2){
return compare(e1.distance,e2.distance);
});
</cfscript>
<cfquery name="sortedZipCodeQuery" dbtype="query">
SELECT *
FROM zipCodeQuery
ORDER BY distance
</cfquery>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
BACFL
AUTHOR
Participant
,
LATEST
/t5/coldfusion-discussions/error-parameter-validation-error-for-the-sort-function-the-function-accepts-1-parameter-s/m-p/10911502#M184520
Feb 08, 2020
Feb 08, 2020
Copy link to clipboard
Copied
@BKBK that did the trick. Many thanks!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

