Reply To: Order By Sort

01/06/2015 at 10:10 am #314108
Steven Zahm
Keymaster

@ Tim

The sorting issue is likely because that field is a text field, not a numerical field. Numerals sorted as text will not sort the way you expect. Here an example…

if sorting 1–10 as numeric in a numeric field you would get 1–10 in order as you expect. However, since it is a text field you would get:

1
10
2
3
4
5
6
7
8
9

Anotehr exmaple:
https://support.office.com/en-au/article/Sort-records-on-numeric-values-stored-in-a-text-field-502a36c4-2b6e-4453-91b6-7e842d234157

So, you’re large numbers are likely in the right spot and not random, given that context.

Probably, depending on what you entered exactly in the zipcode field, you could alter the query Connections makes when ordering by zipcode using this method:
http://sqlserverplanet.com/tsql/how-to-order-numeric-values-in-a-varchar-field

Bets guess without digging deeper, you’d have to add it after this line of code:
https://github.com/Connections-Business-Directory/Connections/blob/develop/includes/class.retrieve.php#L763

Hope that helps!