Re: Strange bind_param issue

2012-09-06 Thread Martin J. Evans
On 15/08/12 17:39, Tim Bunce wrote: On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote: I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 and am at a loss to explain exactly what is happening. I wonder if anyone can help? Some background: DBI says for bi

Re: Strange bind_param issue

2012-08-16 Thread Charles Jardine
On 16/08/12 16:37, Martin J. Evans wrote: On 16/08/12 16:13, Charles Jardine wrote: I thought it might be interesting to see what DBD::Oracle does. I ran use strict; use DBI; my $dbh = DBI->connect("dbi:Oracle:", '', ''); my $obj = new Object(); my $sql = q(SELECT ? AS result from dual); my

Re: Strange bind_param issue

2012-08-16 Thread Martin J. Evans
On 16/08/12 16:13, Charles Jardine wrote: On 16/08/12 14:00, Martin J. Evans wrote: On 15/08/12 17:39, Tim Bunce wrote: On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote: I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 and am at a loss to explain exact

Re: Strange bind_param issue

2012-08-16 Thread Charles Jardine
On 16/08/12 14:00, Martin J. Evans wrote: On 15/08/12 17:39, Tim Bunce wrote: On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote: I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 and am at a loss to explain exactly what is happening. I wonder if anyone ca

Re: Strange bind_param issue

2012-08-16 Thread Martin J. Evans
On 15/08/12 17:39, Tim Bunce wrote: On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote: I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 and am at a loss to explain exactly what is happening. I wonder if anyone can help? Some background: DBI says for bi

Re: Strange bind_param issue

2012-08-15 Thread Martin J. Evans
On 15/08/2012 18:41, Tim Bunce wrote: On Wed, Aug 15, 2012 at 06:02:35PM +0100, Charles Jardine wrote: $obj is not a string. It is an object of a class which has a stringify operator. "$obj" is a string, because "..." stringifies. It is not at all clear how the DBI should take a copy of an obje

Re: Strange bind_param issue

2012-08-15 Thread Tim Bunce
On Wed, Aug 15, 2012 at 06:02:35PM +0100, Charles Jardine wrote: > > $obj is not a string. It is an object of a class which has a > stringify operator. "$obj" is a string, because "..." stringifies. > > It is not at all clear how the DBI should take a copy of an object. Without any method attrib

Re: Strange bind_param issue

2012-08-15 Thread Charles Jardine
On 15/08/12 16:14, Martin J. Evans wrote: I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 and am at a loss to explain exactly what is happening. I wonder if anyone can help? Some background: DBI says for bind_param: "The bind_param method takes a copy of $bind_value

Re: Strange bind_param issue

2012-08-15 Thread Tim Bunce
On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote: > I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838 > and am at a loss to explain exactly what is happening. I wonder if anyone can > help? > > Some background: > > DBI says for bind_param: > > "The bind