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 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
