Jaws wrote at Thu, 03 Apr 2003 14:47:02 +0800: > I tried using the following: > > my $sth = $dbh->prepare(q{INSERT INTO MYTABLE (USERNAME,PASSWORD) VALUES (?, ?) > }) or die $dbh->errstr; > $sth->execute($username,PASSWORD('$pass')) or die $dbh->errstr; > $dbh->disconnect; > > but i got this error: > > Undefined subroutine &main::PASSWORD called at ./adduser.pl line 30, > <STDIN> line 4. > > Any suggestions?
Well, I'm not an expert in this topic, but have you tried my $sth = $dbh->prepare(q{INSERT INTO MYTABLE (USERNAME,PASSWORD) VALUES (?, PASSWORD(?))}); $sth->execute($username, $pass) or die $dbh->errstr; Best Wishes, Janek -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]