How about:
my $sql = "INSERT INTO apidbusers VALUES (?, password(?))";
--jeff
----- Original Message -----
From: "Jianping Zhu" <zjp@stripped>
To: <mysql@stripped>
Sent: Friday, February 28, 2003 2:48 PM
Subject: Re: mysql encripted password from perl
> 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(?, ?)";
> >
> > $sth->execute($username, $password1);
> > In this way, password1 will be in mysql table as plain text.
> > how can i let it appear in mysql table as encripted?
> >
> > Thanks
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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 <mysql-thread133708@stripped>
> > To unsubscribe, e-mail
<mysql-unsubscribe-zjp=arches.uga.edu@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> --------------------------------
> Jianping Zhu
> Department of Computer Science
> Univerity of Georgia
> Athens, GA 30602
> Tel 706 5423900
> --------------------------------
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread133712@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jeff=kilbride.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
