Gossamer Forum
Home : Products : DBMan : Installation :

Sorting..

Quote Reply
Sorting..
   I was wondering if anyone has come up with an addon to do something similar to the following:

Sort all of the records by the date and do an html output with only the date field of all records listed that are anchored (<a href..etc..) to the full record entry.

Richard
Quote Reply
Re: Sorting.. In reply to
JPDeni's Short/Long display mod seems perfect for what you want to do, although you may have to tweak it to suit exactly your needs.

I used it to create a database of Returned Peace Corps Volunteers. Each RPCV enters his/her own information, including name, address, city, state, phone, email, years-served, etc.

The 'short' display shows just their names, email addresses, and years, and includes a link to each 'long' record. Clicking the table headers allows you to resort the list by date or alphabetically by name (sort of like Windows Explorer one-click sorting by filename or date).

This was a great mod -- highly recommended!

You can get it in the resources section off the dbman homepage.
Quote Reply
Re: Sorting.. In reply to
Glen,

Thanks for the info, I appreciate it! Now I have one more question.. Smile If I want to view the records from let's say October 1999, how can I put that in URL form? My date field goes as follows for example October 1, 1999 I have tried the following, but to no avail.

http://url.to.db/db.cgi?uid=default&view_records=1&date=October+1999

and

http://url.to.db/db.cgi?uid=default&view_records=1&date=October+*+1999

Richard
Quote Reply
Re: Sorting.. In reply to
You would link to the detailed/long view in the following manner:

Code:
<a href="$db_script_link_url&ww=on&$db_key=$rec
{$db_key}&view_records=1">$rec{'date'}</a>

You can also hard code this link in the following manner:

Code:
<a href="http://www.myserver.com/cgi-bin/dbman/db.cgi?db=default&uid=default&ww=on&$db_key=$rec{$db_key}&vr=1">$rec{'date'}</a>

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
Quote Reply
Re: Sorting.. In reply to
If you use the short and long display mod, you can put a link in one of the fields in the short view (the example being the date field). And then it will show a detailed view of that record.

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
Quote Reply
Re: Sorting.. In reply to
What do you mean?

Richard