Here's what I am trying to do. I am currently trying to create an array within a query that populates the array with a double number such as 10.21 and the primary key from the query such as 1451. After the query is finished, I want to sort the array by the double number (10.21) and then do a query based on the primary key (1451).
I tried using the key as 10.21 and the val as 1451 and it works, but I may have multiple 10.21 numbers, and it omits it since it is already in use. Also, sorting by the key doesn't consider the key numbers so 2.84 comes after 18.44.
What is a good work around to capture the double and primary key integer and sort the array by the double? I don't mind changing the array around so I don't lose data on the sort, but I still need to sort the array by the double.
Any ideas would be greatly appreciated.