Hi Everyone,
i did the following
$dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied =
'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' )
and the value of the current date and current time were not updated on the
table. It seems perl
were not updated on
the table. It seems perl interpolated the function CURRENT_DATE() and
CURRENT_TIME() .everything else is ok
Why did you put single quotes around the MySql function calls? That tells
MySql that these are strings, not function calls.
Also, you should be using placeholders