Gossamer Forum
Home : Products : DBMan : Discussions :

?How to show descending order when "List All" ?

Quote Reply
?How to show descending order when "List All" ?
When "List All" is selected, I need the records to be displayed in descending order ...

Anyone can help me on how to do it ?
Thanks a Lot !!!


Quote Reply
Re: ?How to show descending order when "List All" ? In reply to
In your link to "List All" you need to add two new options:

&sb=1 Sets the field number to sort results by
&so=ascend Sets the sort order to either ascend or descend

If this is your first time with DBMan, I highly recommend checking out JPDeni's DBMan-ual. It has some great introductory tutorials and can be found at http://www.jpdeni.com/dbman/

Good luck with DBMan!

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: ?How to show descending order when "List All" ? In reply to
Thanks a lot, Astroboy, that was extremely helpful! Sorry for the double posting, but I didn't realize I could get an answer quick. I don't know why "List All" should be ascending by default, it should be descending, as people would always check to see what's new ... And surprisngly I couldn't find any remark on this in the tutorials, etc !

Quote Reply
Are there double quotes or single quotes for so ? In reply to
Are there double quotes or single quotes for so="descend" ?
How exactly can I place it in the "List All Link" ? Sorry, I'm just a beginning Perl user, but this is the only problem I have with the excellent DBMan ...

Thanks, Regards

Quote Reply
Re: Are there double quotes or single quotes for so ? In reply to
Alex included a very helpful summary of search/display options and included it in the README.txt file included with the dbman download.

In Reply To:
Match Case cs=1
Match Whole Word ww=1
Regular Expression re=1
Match Any ma=1
Keywords keyword=?
Sort By Field Number sb=? where ? is the field number indexed from 0.
Sort Ascending Order so=ascend
Sort Descending Order so=descend
There are other samples listed in the file also.

Quote Reply
Re: Are there double quotes or single quotes for so ? In reply to
The link is in the html_footer sub-routine of html.pl. It most liekly looks like this (or something similar, can't remember exactly):
print qq! <a href="$db_script_link_url&view_record=1&$db_key=*">List All</a> |! if ($per_view);

You just need to add the two new variables like such:
print qq! <a href="$db_script_link_url&view_record=1&$db_key=*&sb=1&so=descend">List All</a> |! if ($per_view);

You can customize the variables as I said in my previous post.

Cheers,

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Thanks In reply to
Thanks, Mark, that did it ! Great ! That was my biggest problem with dBMan. Now I can utilize it for our website to full effect. Karen, thanks as well ...

We will slowly bring in this superb script and replace our other scripts at http://www.geocities.com/BourbonStreet/Quarter/9856/jrtlr.html.

Regards
JR