Sorry - I wasn't particularly clear. What I meant to say was that the
request object has a number of collections associated with it (form,
querystring, etc...). When I have used the request object I have always
referenced an element of one of these collections e,g, request.form("un").
Not seen it as you had it but not to say it sdoesn't work! Besides,
assuming you aren't getting an error (just no record returned) then I think
that Randell's post gives you the answer.
-----Original Message-----
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 17:25
To: CF-Talk
Subject: RE: OT - SQL Help
No scope. It is written in ASP.
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:46 AM
To: CF-Talk
Subject: RE: OT - SQL Help
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
