Gossamer Forum
Home : Products : DBMan : Installation :

Displaying results alphabeticly

Quote Reply
Displaying results alphabeticly
How do you set the db up to display the results alphabeticly. I have a ID field for the key field and a name field which I would like to display in alphabetical order after a search.
Quote Reply
Re: Displaying results alphabeticly In reply to
Hi Keswick,

You can use sb=field_number to sort on a particular field. So if your field was 'Name' and it was in position 6, just add:

<input type=hidden name=sb value=6>

to your search form. It defaults to ascending order.

Cheers,

Alex
Quote Reply
Re: Displaying results alphabeticly In reply to
Ok I placed the following line in my sub html_view_search portion of my html.pl file:

<input type=hidden name="db" value="1">

the name of the field I want to sort with is called FName and is in postion 1. This line of code dosen't appear to do anything at all. The names still come up the same way that they were put in. What am I doing wrong?

-Keswick
Quote Reply
Re: Displaying results alphabeticly In reply to
Ow yeah one other thing I can't find a field called db field_number in any of the files. How is that supposed to work?