On 03/01/11 21:03, David Nicol wrote:
> 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.
It doesn't.
BTW, when I said what is %attr used for on prepare, I realise it is used to
pass driver attributes but that is not obvious from the DBI pod. I don't
believe it is currently used for anything DBI specific.
> does
>
> my $sth;
> {
> local $$dbh{ChopBlanks} = 1;
> $sth = $dbh->prepare($sql)
> };
>
> work?
>
>
>
Yes, that works, it was one of my examples.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
