I should have suggested the use of the ENCRYPT() function, not CRYPT()
(since the latter, like PASSWD(), doesn't exist! ;) .

Thus, the update query should properly be:

  UPDATE vpopmail SET pw_passwd=ENCRYPT('newpassword') WHERE
  pw_user='someuser';

Sorry for the confusion...

/pg
-- 
Peter Green : Gospel Communications Network, SysAdmin : [EMAIL PROTECTED]
---
I made that book [_Sex_] because...uh...because...um...uh...I don't know
*why* I made that book.
(Madonna, to David Letterman)

Reply via email to