Gossamer Forum
Home : Products : DBMan : Customization :

Sorting table in dbman

Quote Reply
Sorting table in dbman
I am Polish so I would like dbman to sort search results in Polish. I use the iso-8859-2 character set, and I would like some characters with codes greater than 128 appear before characters from standard ascii table. I guess I should use my own sorting table, but need some help with this.
Quote Reply
Re: Sorting table in dbman In reply to
You didn't understand me, maybe my English is poor, i will give you an example:
records are sorted by i.e. Title field, ac. order, result is: (first letters of titles)
abcdefghijklmnopqrstuvwxyz¹³æ¿Ÿñóœ
(if you can't see the last characters properly switch your browser to iso-8859-2 encoding).
it should be sorted that way:
a¹bcædeêfghijklmnñoópqrstuvwxyz¿Ÿ,
you know, we have that kind of alphabet in Poland. but our national characters have codes greater than 0-127 range, so the results of sorting by just comparing ascii codes of characters is wrong.
Quote Reply
Re: Sorting table in dbman In reply to
DBMAN sorts by fields one at a time in each form. What you need to do is add some hidden fields in your search forms in the following sub-routines: (view_search, modify_search, delete_search)

Code:
<input type="hidden" name="sb" value="fieldnumber">
<input type="hidden" name="so" value="descend">

Change the fieldnumber to the field that you want to sort by and then change the descend value if you want the field to be sorted in ascending order (1-10, A-Z) rather tha descending order (10-1, Z-A).

Hope this helps.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us