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.
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)