Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

Fixed 'sort by' field

Jun 23, 2000, 12:34 PM
omegadm
User (130 posts)
omegadm's avatar
Jun 23, 2000, 12:34 PM
Post #1 of 3
Views: 1216
Shortcut
Quote Reply
Fixed 'sort by' field
Is it possible to have the 'sort by' field fixed in the search table??

i.e. not a drop-down list, but a fixed data column value such as 'Price'. The ascending/descending drop-down would still apply.

Best regards, Brian

Jun 23, 2000, 2:06 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 23, 2000, 2:06 PM
Post #2 of 3
Views: 1152
Shortcut
Quote Reply
Re: Fixed 'sort by' field In reply to
Sure.

In sub html_search_options, delete:

Code:

Sort By:
<SELECT NAME="sb">
<OPTION>---
~; for (my $i =0; $i <= $#db_cols; $i++) { print qq~<OPTION VALUE="$i">$db_cols[$i]</OPTION>\n~ if ($db_form_len{$db_cols[$i]} >= 0); } print qq~
</SELECT>
and insert

Code:

<input type="hidden" name="sb" value="the number of the field you want to sort by">
JPD
http://www.jpdeni.com/dbman/
Jun 24, 2000, 7:51 AM
omegadm
User (130 posts)
omegadm's avatar
Jun 24, 2000, 7:51 AM
Post #3 of 3
Views: 1144
Shortcut
Quote Reply
Re: Fixed 'sort by' field In reply to
Thanks JPD

What a great program ;-)

Best regards, Brian