perl mysql problem with NOW() 1

[iluvperl]

use DBI;
my $dbh = DBI->connect("DBI:mysql:$dbase", $mysql_user, $mysql_pass) o
+r
print DBI->errstr;

  my $data = qq(INSERT INTO searches (search, engine, time) values(?,?
+,?));
  my $sth = $dbh->prepare($data);
  $sth->execute("$search", "$engine", NOW());

It says NOW() is an undefined subroutine. Any idea why?

 

[1DMF]

I'm not aware of NOW() being a perl time function that's VB isn't it?

look here for date/time functions in PERL

http://www.perl.com/pub/a/2003/03/13/datetime.html

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[BrianAtWork]

The NOW function is a part of MySQL, not perl. Just include the NOW statement in your prepare statement instead of in your perl code, and it should work better.

my $data = qq(INSERT INTO searches (search, engine, time) values(?,?,NOW()));

 

[iluvperl]

Thank you Brian, that worked!

 

[1DMF]

star for you biran!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[BrianAtWork]

Glad I could help!

And thanks for the star!