Re: mysql encripted password from perl

2003-02-28 Thread KH Chiu
change $sql .= "VALUES(?, ?)"; into $sql .= "VALUES(?, password(?))"; Please note that password is a mySQL function and not a PERL function. So, you need to use the password function again in verify the password. Regards, KH > I have perl code like >my $username = $query->param("user

Re: mysql encripted password from perl

2003-02-28 Thread Jeff Kilbride
How about: my $sql = "INSERT INTO apidbusers VALUES (?, password(?))"; --jeff - Original Message - From: "Jianping Zhu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 2:48 PM Subject: Re: mysql encripted password from

Re: mysql encripted password from perl

2003-02-28 Thread Jianping Zhu
sth->execute($username, password($password1)) does not work. On Fri, 28 Feb 2003, Jianping Zhu wrote: > > I have perl code like >my $username = $query->param("username"); >my $password1 = $query->param("password1"); >my $sql= "INSERT INTO apidbusers "; > $sql .= "VALUES(?, ?)";