> Sorry for the OT but this should be a quick answer.
> This is in ASP (sorry).
>
> If I have the following:
> sql = "SELECT * FROM SomeTable "
> sql = sql & "WHERE Email = '" & Request("un") & "'"
> sql = sql & " OR SEmail = '" & Request("un") & "'"
> sql = sql & " AND IsDeleted = 0 "
> sql = sql & " AND Password = '" & Request("pw") & "'"
> sql = sql & " AND Approved = 1 "
> sql = sql & " AND Registered = 1 "
>
> Where Email is the "primary" email and SEmail is a
> "secondary" email address (both are different addresses).
> If the submission doesn't match the first then it matches
> the second, how do I account for that? Right now, I am
> getting an error because the record doesn't match.
You shouldn't be getting an error if the record doesn't match, you should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
