This topic is locked

Problem with Ordering

10/16/2006 9:39:55 PM
PHPRunner General questions
S
steviechan83 author

Hi Everybody,
I have problems with the ordering of the data. It is okay when the data is ordered initially using the ORDER BY Box. However if i can click it to order by a certain category then the ordering does not work. The ordering does not sort properly.
How can i fix this? is this a known problem with v3.1 build 151. Also I am using this security mode: users can see all records, edit their own data only.
Thanks
Stephen

Alexey admin 10/17/2006

Stephen,
are you trying to search on Lookup wizard fields ?

If so your records are sorted on the actual content of the field, i.e. Link field values, not the Display field.
Here is the article describibng how to sort on lookup values

http://www.xlinesoft.com/articles/search_s...okup_values.htm