Search form stopped working

This search form has stopped working. I have not touched the form in a couple of months, and now it's not pulling up any results, even though I know I'm entering valid data.

Also, why do you not allow RAR files to be uploaded for the forums?

Thanks!

If it was working before, I would start by looking at the data.

the recordset being used has a couple of INNER JOIN statements.

using an INNER JOIN means that a result will only be returned if there is data in both tables to satisfy the join criteria.

for example, the first inner fjoin:
FROM dbo.tblApplicationScores INNER JOIN
dbo.tblScoringGroups ON dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroup


if there is not a record where:
dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroup


no result will be returned.

try changing the join types to see if that effects the results using LEFT, RIGHT or OUTER joins.

I took away the inner join statement from all of the tables, and it's still not working.

Actually, using an inner join did return results - at least in the query, because the tables are fully populated with info from the other tables, if that makes sense.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.