make sure the field definition where you store your password is at least 16
bytes size (i.e. char(16) or varchar(255) or something). i guess such must
be a problem since your query looks just fine.
gl
rene
----- Original Message -----
From: "jsimlo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 2:16 PM
Subject: question ...
> Hi,
> i have a big problem ... why this doesnt work?:
>
> INSERT INTO mytable (login, heslo) VALUES ('login', Password('heslo'));
> SELECT * FROM mytable WHERE login='login' AND heslo=Password('heslo');
>
> the second line gives me no result ... i have spent a lot of
> time looking at that, but i cant find, where the problem is,
> but the password function ... i have read all the
> documentation around it, but i have no idea, whats wrong ...
> if you can help me, please tell me, whats wrong ... thanx a
> lot, jsimlo ;)
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
