Android Question Sorting Mysql data the second time

[toby]

My app gets data (ID, name, creationDate) sorted by a creationDate, in the form of list of maps, from mysql using php. I then create a corresponding list of arrays, which is used to populate a b4xTable.

Now I need to sort the same data by ID column instead. I know that I could query mysql to get another copy of data sorted by ID column, and I'm wondering whether there is an easy way to avoid the second round trip to the remote server.

Thanks in advance for your helps!

 

[TILogistic]

sort:

B4XTable
.InternalSortMode

B4XTable1.AddColumn("Name", B4XTable1.COLUMN_TYPE_TEXT).InternalSortMode = "DESC" 'or "ASC"
'or
Dim c As B4XTableColum = B4XTable.AddColumn(...)
c.InternalSortMode = "ASC"

Map

[B4X] B4XCollections - More collections

B4XCollections is a b4x lib. It adds several cross platform collections. It includes a static module named B4XCollections which should be used to create new instances of the collections. You can either create new empty collections or pass the initial data. B4XSet - A set is a collection of...

www.b4x.com

Array (QuickSort)

Sorting algorithms - Teaching with Basic4android

Implementations of sorting algorithms are useful for teaching fundamental concepts such as algorithms analysis, complexity and data structures. The following code includes implementations of the following sorting algorithms: bubble sort, selection sort, quick sort, merge sort and binary tree...

www.b4x.com