Skip to main content
B
BACFL
Inspiring
February 7, 2020
Answered

Error: Parameter validation error for the sort function. The function accepts 1 parameter(s)

  • February 7, 2020
  • 1 reply
  • 1068 views

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>

 

This topic has been closed for replies.
Correct answer BKBK

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>

 

1 reply

BKBK
Community Expert
BKBKCommunity ExpertCorrect answer
Community Expert
February 7, 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>

 

    B
    BACFLAuthor
    Inspiring
    February 8, 2020

    @BKBK that did the trick. Many thanks!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices