This and CFDJList are the only good lists that are out there where everyone is more than helpful and help/answers are extrememly quick.
-----Original Message----- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:38 PM To: CF-Talk Subject: RE: OT - SQL Help That is pretty funny, posting an SQL question wrapped in ASP on a Cold Fusion list. I have a question about using linked lists and malloc in C :) Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -----Original Message----- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:25 AM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
