[thelist] ASP & SQL

[Jay Blanchard]

--
[snip]
i say build your query based on the information you DO have. for
example...

if you have all three variables, do something like this...

SELECT fname, lname, location
 FROM employees
 WHERE fname = <varFName> AND
       lname = <varLName> AND
       location = <varLocation>

alternatively, if you've only got First Name and Location to work
with...

SELECT fname, lname, location
 FROM employees
 WHERE fname = <varFName> AND
       location = <varLocation>

and one more example (First Name, Last Name)...

SELECT fname, lname, location
 FROM employees
 WHERE fname = <varFName> AND
       lname = <varLName>


this requires a little more scripting and maybe some If statements, but
i don't know enough about SQL to write a complete query that would do
the same thing.
[/snip]

Don't forget just Last Name and Location. And actually you would want to
build queries on single items as well...

First Name Only
Last Name Only
Location Only
First Name & Last Name & Location
First Name & Last Name
First name & Location
Last Name & Location

So you have to be prepared to build 7 queries based on information supplied.
You can use a CASE statement to encase them all.

HTH!

Jay
--
[ winmail.dat was deleted, please don't send attachments with your message. ]
--