On Fri, 23 Nov 2001 16:17, De Necker Henri wrote:
> I have the following query
> $query = "INSERT INTO acl ( username, password )
> VALUES ( 'henri', ENCRYPT('diesel','henri') )";
>
> This is the error i get :
> Column 'password' cannot be null
> What is wrong with my query?
Mysql docs say:
ENCRYPT(str[,salt])
Encrypt str using the Unix crypt() system call. The salt argument should
be a string with two characters. (As of MySQL Version 3.22.16, salt may be
longer than two characters.):
mysql> select ENCRYPT("hello");
-> 'VxuFAJXVARROc'
If crypt() is not available on your system, ENCRYPT() always returns NULL.
ENCRYPT() ignores all but the rst 8 characters of str, at least on some
systems.
This will be determined by the behavior of the underlying crypt() system
call.
#####
It may be that you don't have crypt on your system; also, you might want
single quotes around the ENCRYPT and double quotes to delimit the string
and salt, thus:
VALUES ( 'henri', 'ENCRYPT("diesel","henri")' )";
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
" ," said Tom blankly.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
