MySql function

From: akpome_perl@xxxxxxxxx (Akpome Akpoguma)
Date: Wed, 26 Apr 2006 09:05:32 -0700 (PDT)

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 interpolated the function CURRENT_DATE() and CURRENT_TIME() .....everything else is ok

can someone help with a way out.

Rgds

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Follow-Ups:
- RE: MySql function
  - From: Ronald J Kimball

References:
- Oracle functions through DBI?
  - From: Riccardo Bonuccelli

Prev by Date: Oracle functions through DBI?
Next by Date: RE: MySql function
Previous by thread: Oracle functions through DBI?
Next by thread: RE: MySql function
Index(es):
- Date
- Thread