I'm a bit confused - I'm not sure what you mean by the error you are
getting. What scope are you trying to request the variable un from? Is it a
form variable or url? Normally you'd access these using Request.Form("un")
(for form vars)
If they are local vars then just reference them as "un". Not saying that
what you have will cause errors - just not seen it written like that b4.
-----Original Message-----
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 16:31
To: CF-Talk
Subject: OT - SQL Help
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
