post a copy of your table and what you expect to see from a pseudo query.
Normally, to filter, your query should be something like...
"SELECT * FROM tablename WHERE fieldname = 'some criteria' "
btw * is lazy, you should only realy select the fields you want to see, but it will get you started
If your query is working ok, you should be able to see the values returned when you test the recordset in dreamweaver.
If this is Ok, then perhaps you have a problem with your repeat region