Skip to main content
G
GaryNY
Known Participant
October 2, 2009
Question

How to sort array of structures

  • October 2, 2009
  • 1 reply
  • 1384 views

Hi !

I populated an array of structures:

ind is increased in a query loop:

<CFSET TD[ind] = StructNew()>

<cfset TD[ind].V1 = "#qryTermst.v1#">

<cfset TD[ind].V2 = "#qryTermst.v2#">

<cfset TD[ind].V3 = "#qryTermst.v3#">

<cfset TD[ind].D = "#DateFormat(qryTermst.date, 'M/D/YYYY')#">

<cfset TD[ind].V5 = "#qryTermst.v5#">

After the array is populated- later - I need to display it in descending order of D (dates) and in ascending order of V1.

I tried to use the StructSort function, but did not get results.

Any help will be appreciated !

Regards !

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    October 2, 2009

    Are you sure you need an array of structures?  If every structure has the same format, you might be able to achieve your final goal with a query object instead.  They are much easier to sort.

    Once you figure out how to sort, you will find that you are probably not getting the desired results.  You are storing your date as a string instead of a date object, so it will sort as a string.  Now look at the format you chose.

    G
    GaryNYAuthor
    Known Participant
    October 3, 2009

    Sorry, but I next prepare reports based on the elements of this array (of structures).

    So it is easier for me to store data (which I actually read from a query object) in this array...

    I actually tried to sort an array- prepeared an array of keys- then (in cfloop) tried to read "sorted" elements (structures) - got error, so far.

    There must be an easy way to sort at least some keys- like I tried.

    Any ideas ?

    Samples ?

    Thanks !

    Gary.

    A
    Adam Cameron.
    Inspiring
    October 4, 2009

    I gotta agree with Dan here.  An array of struts isn't such a good data structure for you to land yourself with here.  But I suppose it can't be helped.

    Sorry, but I next prepare reports based on the elements of this array (of structures).

    Do you mean the code for the reports already exists and expects an array of structs?  And you can't change that?

    Anyway, if you're stuck where you are, you should perhaps look @ the quickSort() function on cflib.org: http://www.cflib.org/udf/QuickSort

    I've never used it, but it sounds like it'll do what you want.

    --

    Adam

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