Hi all,
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.
Any ideas?
Thanks,
Tony
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
