Re: DBI Modifying a bind value

Can't modify non-lvalue subroutine call

You'll have to use an intermediate variable to do the substitution, and then pass that variable to fill in the placeholder:

my $create_date = $row->find ("CreateDate")->string_value();
$create_date =~ s/(\d\d\d\d-\d\d-\d\d)T(\d\d:\d\d:\d\d+).*00/$1 $2/g;
$dbh->do(..., 
         $create_date, 
         ...
[download]

Not beautiful, but that's how life is, sometimes :)

Comment on Re: DBI Modifying a bind value Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI Modifying a bind value by journey (Monk) on Oct 08, 2009 at 02:42 UTC
Fabulous! I was scared to use an intermediate variable and mess up the binding. It just did not occur to me that I could insert it just before the "do" call... Many thanks!	[reply]