Sorting XML

[Zenfish]

Hi,

I'm currently playing with Datamaker and I was wondering if there any trick/method(array?)/action to sort XML result.
Seems it's unfortunatly impossible to sort using xPathquery...

For exemple:

Code: [Select]

<ITEM id="1" categorie="sword" name="Cool Sword" price="3" pwr="2">/ITEM>
<ITEM id="2" categorie="axe" name="Super axe" price="5" pwr="3"></ITEM>Using following action: XML Select Node->Xml Get Next Node List Properties and then iterate a game object to get a list with name, price and PWR.
I would love now to be able to sort these iterations by name, price or pwr.(create a table where i can sort columns)


Thanks!

[jeanfabre]

Hi,

 for this kind of sorting, here's what I do.

 I create a hashtable for each column, where the key is the ID value ( as a string)

then on the column you want to sort, extract the values from the hashtable, into am arraylist, sort that, and then you can look up the key for that value, and with that key, get all the rest of the row.

 Bye,

 Jean

[Zenfish]

Thanks Jean!

I'll try this. It will be my challenge of the week

[MS80]

Hi,

 for this kind of sorting, here's what I do.

 I create a hashtable for each column, where the key is the ID value ( as a string)

then on the column you want to sort, extract the values from the hashtable, into am arraylist, sort that, and then you can look up the key for that value, and with that key, get all the rest of the row.

 Bye,

 Jean

Hi.

I was wondering if this is still the best solution to sort xPathquery results?
Are the any other solutions out there?

Thanks!