Gossamer Forum
Home : Products : DBMan : Customization :

View - Ascending Order

Quote Reply
View - Ascending Order
Hi - Don (our webmaster) had to go away on an extended leave and we have put together a few of our alumni to try and take care of things while he is away. He has been very good at documenting things for us.

However, we just noticed something changed in our database when Don converted from the old html.pl to the new friendly-html.pl

Before when choosing view, modify, or list all the results were returned in ascending order (alphabetical). However, now when we choose the same links the results are not ascending any longer. Could you tell us where to make a change to accomplish alpha order of results again please?

Thank-you

Dedra
Quote Reply
Re: View - Ascending Order In reply to
Do you want the records to be listed alphabetical by last name (A-Z)?

If so, then use these code in the sub-routine where you have the search form (and modify forms):

Code:
<input type=hidden name="sb" value="FieldNumber">
<input type=hidden name="so" value="ascend">

Replace the FieldNumber with the field number you have in the configuration file (.cfg) for either the First Name or Last Name.

You can add these codes to other form routines in your html.pl file.

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

[This message has been edited by Eliot (edited September 04, 1999).]
Quote Reply
Re: View - Ascending Order In reply to
Oh my - this is real technical support. Thank you so much for your help Eliot we have now changed html.pl our database now displays the names in alphabetical order like we wanted.

Thank-you

Dedra
Quote Reply
Re: View - Ascending Order In reply to
You're welcome. Glad it worked.

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