At 8:09 AM -0600 9/20/03, Stout, Jeff wrote:
Thanks John, I'm trying various syntax changes but still getting
Empty set
mysql> INSERT INTO user_profile (userid,password)
-> VALUES ("James",AES_ENCRYPT("bond","007"));
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM user_profile WHERE us
> SELECT username, AES_DECRYPT(password,"sydo89") AS psw
> FROM user_profile
> WHERE personid=1
retrieves the username and the clear password
regards
benny
- Original Message -
From: "Stout, Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
Thanks John, I'm trying various syntax changes but still getting
Empty set
mysql> INSERT INTO user_profile (userid,password)
-> VALUES ("James",AES_ENCRYPT("bond","007"));
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM user_profile WHERE userid="james" AND
-> AES_DECRYPT("passw
