Firstly, apologies for starting a thread and then being too busy to
follow it up - I really have been very busy but I would like to make
some progress with this.
On 10/01/2011 22:35, Tim Bunce wrote:
On Mon, Jan 03, 2011 at 02:50:21PM +, Martin J. Evans wrote:
On 03/01/2011 13:08, Tim Bun
On 10/01/2011 22:35, Tim Bunce wrote:
On Mon, Jan 03, 2011 at 02:50:21PM +, Martin J. Evans wrote:
On 03/01/2011 13:08, Tim Bunce wrote:
Generally "method attributes" and "handle attributes" are quite
distinct. The one place they're not is the connect() methods that create
a statement handl
On Mon, Jan 03, 2011 at 02:50:21PM +, Martin J. Evans wrote:
> On 03/01/2011 13:08, Tim Bunce wrote:
> >
> >Generally "method attributes" and "handle attributes" are quite
> >distinct. The one place they're not is the connect() methods that create
> >a statement handle.
> >
> >It's an unfortuna
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 mo
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 w
On 03/01/2011 14:50, Martin J. Evans wrote:
On 03/01/2011 13:08, Tim Bunce wrote:
On Mon, Jan 03, 2011 at 11:52:45AM +, Martin J. Evans wrote:
Ok, as I suspected, this was sort of my fault. You can indeed do:
$h = DBI->Connect;
$s = $h->prepare(q/select * from sometable/);
$s->{ChopBlanks}
On 03/01/2011 13:08, Tim Bunce wrote:
On Mon, Jan 03, 2011 at 11:52:45AM +, Martin J. Evans wrote:
Ok, as I suspected, this was sort of my fault. You can indeed do:
$h = DBI->Connect;
$s = $h->prepare(q/select * from sometable/);
$s->{ChopBlanks} = 1;
and it chops blanks but you cannot do:
On Mon, Jan 03, 2011 at 11:52:45AM +, Martin J. Evans wrote:
> Ok, as I suspected, this was sort of my fault. You can indeed do:
>
> $h = DBI->Connect;
> $s = $h->prepare(q/select * from sometable/);
> $s->{ChopBlanks} = 1;
>
> and it chops blanks but you cannot do:
>
> selectall_arrayref(q/
Ok, as I suspected, this was sort of my fault. You can indeed do:
$h = DBI->Connect;
$s = $h->prepare(q/select * from sometable/);
$s->{ChopBlanks} = 1;
and it chops blanks but you cannot do:
selectall_arrayref(q/select * from sometable/, {ChopBlanks => 1});
or
prepare(q/select * from sometab
On Mon, 03 Jan 2011 10:27:52 +, "Martin J. Evans"
wrote:
> On 02/01/2011 18:50, H.Merijn Brand wrote:
> > On Sun, 02 Jan 2011 18:07:13 +, "Martin J. Evans"
> > wrote:
> >
> >> Sorry if this turns out to be gibberish but I'm been battling with a
> >> host of unicode problems today and I
On 02/01/2011 18:50, H.Merijn Brand wrote:
On Sun, 02 Jan 2011 18:07:13 +, "Martin J. Evans"
wrote:
Sorry if this turns out to be gibberish but I'm been battling with a
host of unicode problems today and I am quickly losing track.
I can't make ChopBlanks work properly in DBD::ODBC. It wo
On Sun, 02 Jan 2011 18:07:13 +, "Martin J. Evans"
wrote:
> Sorry if this turns out to be gibberish but I'm been battling with a
> host of unicode problems today and I am quickly losing track.
>
> I can't make ChopBlanks work properly in DBD::ODBC. It works if I use:
>
> $dbh->{ChopBlanks}
Sorry if this turns out to be gibberish but I'm been battling with a
host of unicode problems today and I am quickly losing track.
I can't make ChopBlanks work properly in DBD::ODBC. It works if I use:
$dbh->{ChopBlanks} = 1;
$sth = $dbh->prepare(q/select * from sometable/);
and does not work
13 matches
Mail list logo