From: Fred Lindberg
Date: March 15 1999 8:32pm
Subject: Re: how to select password(...)?
List-Archive: http://lists.mysql.com/mysql/280
Message-Id: <19990315203410.2608.qmail@id.wustl.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

On Mon, 15 Mar 1999 21:08:12 +0100, Thomas Wana wrote:

>I thought that would work:
>select * from user where Name=[name from web-interface] and
>   Pass=password('[password from web-interface]');
>
>When there is a row returning, then the username and password are correct.
>
>My problem: there is always an "empty set" returning.

Try SELECT password('[password from web-interface]');

If that doesn't match the entry then 'password from web-interface' is
wrong. If it looks correct, look for non-printables (e.g. ^M) in that
string. The same problem could exist in the user name.


-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)