RE: SQL Select statement

From: Richard Bewley (rbewley at friend dot ly dot net)
Date: Sun Mar 07 2004 - 18:31:53 EST

  • Next message: Patrick Ben Koetter: "Re: SQL Select statement"

    Sorry, I meant select password...

    Richard

    -----Original Message-----
    From: Richard Bewley [mailto:rbewley at friend dot ly dot net]
    Sent: Sunday, March 07, 2004 6:21 PM
    To: 'cyrus-sasl at lists dot andrew dot cmu dot edu'
    Subject: SQL Select statement

    Hi,

    In our database, we have multiple users with the same username, and
    different passwords. Both must authenticate. Currently, we have:

    select username from users where username='%u' and active='1';

    The problem is, only the first row returned works, so the second user won't
    authenticate. Is there any way to tell is to select where username='%u' and
    password='%password'?

    Thanks,
    Richard


  • Next message: Patrick Ben Koetter: "Re: SQL Select statement"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD