I guess I must have not been clear in my initial email. I am not getting an error. The "problem" is I have 2 different email addresses that can be used to log into an extranet. If the "primary" email doesn't match the "primary" email address then it should check to see if it matches the "secondary" email address and log in otherwise it is not found.
For example, let's say these fields are in the DB: PEmail,SEmail and let's say these are the email addresses respectively: [EMAIL PROTECTED],[EMAIL PROTECTED] And in the form I input [EMAIL PROTECTED] I should be able to log in but the problem is that it only accepts the primary email address. Hope this clears it up. Thanks, Tony -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:22 PM To: CF-Talk Subject: RE: OT - SQL Help What error are you getting? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:14 PM To: CF-Talk Subject: RE: OT - SQL Help No it did not. It's very bizarre. -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:04 PM To: CF-Talk Subject: RE: OT - SQL Help my ASP's not what it used to be! - so did Randells post sort it? -----Original Message----- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:59 To: CF-Talk Subject: RE: OT - SQL Help Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help > 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 doesn't work! You can use either syntax in ASP. I've generally used the more explicit syntax, myself. 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
