Search and results pages

[jisoo22]

Hello people!

Ok so I went through the tutorials and used the generic ways to create a search page (with multiple parameters) and a details (aka results) page. Here's the problem, when I enter something to test the search, the results pages always displays ALL the records instead of just the record or records I'm searching for. It looks like everythings in order...search page had 3 separate fields in a form, set to "GET" method...results page has recordset, dynamic text fields, and repeat region. The recordset on the results page has the appropriate SQL statements:


SELECT Contact_ID, Name, Company
FROM Main_Info
WHERE Company LIKE 'varCompany' AND Name LIKE 'varName'


(varCompany = Request.QueryString("Company&quot, default set to "%". Same with varName)

Does anyone know what the heck is going on?

Thanks,
Jisoo22

 

[jisoo22]

Ok so after testing some, I find that it's narrowed down to this: The Contact_ID does not single out the number I enter as a parameter, it just pulls up all records on hand. Help!

Thanks,
Jisoo22