[thelist] ASP & SQL

Paul Cowan evolt at funkwit.com
Thu Sep 12 20:04:01 CDT 2002


Josua Olson wrote:

> No, bad, grrr...
>
> Just build one query. :-)
>
> But, make it a dynamic query, such as:

<snip>

or, build a query with something like:

SELECT fname, lname, location
 FROM employees
 WHERE
    ((fname = <varFName>) OR (<varFName> = '')) AND
    ((lname = <varLName>) OR (<varLName> = '')) AND
    ((location = <varLocation>) OR (<varLocation> = ''))

This would probably be the best way if you were using prepared
statements/stored procs in something like SQL Server, because the
DB can come up with a nice cached query plan for that, rather than
working it out again each time.

I'm a SQL Server guy, not an Access guy, so doing all this DB-side
may not help you at all. Might make for neater code though....

(oh, and if NULL values are an option, deal with accordingly)

Paul




More information about the thelist mailing list