From: Richard Bewley (rbewley at friend dot ly dot net)
Date: Sun Mar 07 2004 - 18:31:53 EST
Sorry, I meant select password...
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
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