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"
, default set to "%". Same with varName)
Does anyone know what the heck is going on?
Thanks,
Jisoo22
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"
Does anyone know what the heck is going on?
Thanks,
Jisoo22