Re^2: DBI:mysql date conversion question

in reply to Re: DBI:mysql date conversion question
in thread DBI:mysql date conversion question

my $sth = $dbh->prepqre(q~
(   indate,  siteid,serial,contract,installdate) 
values
(CURDATE(),        ?,    ?,       ?, STR_TO_DATE(?,'%m/%d/%Y')   )
~);

$sth->execute( $frame_siteid, $frame_serial, $frame_contract, $frame_i
+nstalldate );
[download]

Comment on Re^2: DBI:mysql date conversion question Download Code

Replies are listed 'Best First'.
Re^3: DBI:mysql date conversion question by ikegami (Patriarch) on Sep 22, 2008 at 03:16 UTC
`my $sth = $dbh->prepqre(q~` [download] should be `my $sth = $dbh->prepare(q~ insert into frame` [download]	[reply] [d/l] [select]
Re^4: DBI:mysql date conversion question by Anonymous Monk on Sep 22, 2008 at 07:10 UTC
I type with heavy accent :D	[reply]

In Section Seekers of Perl Wisdom