On Mon, Jan 3, 2011 at 8:56 AM, Martin J. Evans
> I did think of one spolier which I forgot to mention. Currently DBI allows
>
> prepare($sql, {ChopBlanks => 1});
>
> and ChopBlanks is ignored silently so if you wrote code which understood
> this and moved to another machine where DBI did not, it would be ignored
> silently but your code might not work as intended.
after reviewing the doc and seeing that prepare takes the \%attr I was
surprised that that doesn't do what you want.
does
my $sth;
{
local $$dbh{ChopBlanks} = 1;
$sth = $dbh->prepare($sql)
};
work?
--
"For unknown reasons, Earth sped up in 1999" --Wikipedia on the Leap Second