no records are returned if some search fields are left blank
Posted on 2004-04-24
DW MX 2004 7.01, ASP VBScript, Access DB
I have created a standard search/results set. If I submit the search page with some fields left blank, the results page will have no records. The search page form submission method is GET. Here is my SQL statement:
WHERE request_date = #VARrequest_date#
AND requested_by = 'VARrequested_by'
AND job_ep = 'VARjob_ep'
AND deadline = 'VARdeadline'
I would like to return records based on whatever fields the user fills in, and ignore the blank ones.