B4J Question Preserve mysql table fields order in json

[le_toubib]

Hi
When Getting the list of maps from mysql php , the fields order is distorted , how to keep it with the same fields order as in original table .
P.s : it's too difficult for me to migrate to jrdc now
Thanks

 

[Erel]

The internal json library will not preserve the order of map items (lists are preserved).

Relying on the order of map keys is usually a mistake. Send the column names in a list and use that list to recreate the items in the correct order.

 

[KMatle]

Just create a simple map (in Globals) with the columnnames as the key and the position as the value. When you load the map (row) get the real position from the map.

Another one: Mostly you get the single column out of the map by name and then you know where to put it.

 

[le_toubib]

Just create a simple map (in Globals) with the columnnames as the key and the position as the value. When you load the map (row) get the real position from the map.

Another one: Mostly you get the single column out of the map by name and then you know where to put it.

Thanks .
I used the query :
"SHOW COLUMNS FROM tablename"
To Load a list of column names beforehand ..
Since i needed to use it dynamicaly for multiple tables