|
e3stone
Average Member
USA
885 Posts |
 Posted - 30 April 2001 : 03:55:34
|
I have a database that I need to filter the results from. This is the search page: http://www.insidewaco.com/3320/search.asp
by default it returns just the skill that the user chooses, but if they select more filtering variables, then it'll filter the data based on those criteria. Here's the SQL that I have right now. This will just return all the database that equals the skill they choose:
quote:
strSQL2 = "SELECT DISTINCTROW EMPLOYEE.LAST_NAME, POS.DEPT, SKILL.TYPE, SKILL.PROF, SKILL.YRS_EXP, EMPLOYEE.EMPNO, POS.TITLE, POS.MGR"
strSQL2 = strSQL2 & " FROM (SKILL INNER JOIN EMPLOYEE ON SKILL.EMPNO = EMPLOYEE.EMPNO) INNER JOIN POS ON SKILL.EMPNO = POS.EMPNO"
strSQL2 = strSQL2 & " ORDER BY SKILL.TYPE, SKILL.PROF, SKILL.YRS_EXP DESC"
rs2.Open strSQL2, my_Conn, 1
I just need to be able to filter the data down even more...and I'm not sure how to do that.
Here are the asp pages I'm using:
http://www.insidewaco.com/3320/search_results.txt
and
http://www.insidewaco.com/3320/search.txt
Here's the database if you want to download it: http://www.insidewaco.com/3320/db97_convert.mdb
Thanks
<-- Eric -->
http://insidewaco.com/forum
Edited by - e3stone on 30 April 2001 04:00:00
Edited by - e3stone on 30 April 2001 04:03:28 |
|
Topic Locked
