I am having problems getting the "Sort By" search option to work. The problem is that when I conduct a search on the database for a keyword and then select a variable, it will show results accross all variables. Do I need to change something in the default.cfg file that will allow the "Sort By:" option to work?

Feel free to take a look at our Employee Directory (using DBMan):

http://www.coco.cc.az.us/cgi-bin/dbman/db.cgi

To login, use the following access information:

Userid: guest
Password: guest

To test the SORT BY option, type in "Computer" in the keyword blank, and then
select Department. You should get a bunch of results with "Computer" in it accross other variables.

Any suggestions would be helpful!

:-)

Thanks,

------------------
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

[This message has been edited by Eliot (edited April 09, 1999).]

That's how the keyword search works. It looks in every field for the keyword. The "sort by" is working just fine. I tried sorting by different fields and there was no problem.

What is it that you want it to do?

------------------
JPD

Well, I would like it so that if you select "Department" and type in "Computer", it will only show results in "Departments" with the keyword "Computer". The problem is that you type "Computer" in the keyword blank, then select "Department", you get three results:

ONE result With "Computer" Information Systems.

TWO results With "Computer" in the Position field.

for a total of three results, when there should only be one result with "Computer" in the "Department" field.

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

You'll need to use a search form that has the different fields to search in, then.


------------------
JPD

Thanks! I will try that.

------------------
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

Thank you very much! I created two sub-routines within the html.pl file and referenced them in the db.cgi file: 1) a simple search form with the most pertinent fields and 2) an advanced search form.

It works like a charm.

------------------
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