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/
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 !
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 ...
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
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.
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.