Re: confused about DBD implementation of ChopBlanks

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