Skip Menu |

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 50719
Status: resolved
Priority: 0/
Queue: DBD-ODBC
People
Owner: Nobody in particular
Requestors: bohica [...] ntlworld.com
Cc:
AdminCc:
Bug Information
Severity: Unimportant
Broken in: 1.23
Fixed in: 1.28_5

History Show all quoted text
  Wed Oct 21 16:13:02 2009 bohica [...] ntlworld.com - Ticket created
Subject: ParamTypes in DBD::ODBC not visible until after execute
ParamTypes attribute is not available until after calling execute - this appears contrary to the DBI spec. Martin -- Martin J. Evans Wetherby, UK
  Tue Mar 08 04:45:25 2011 bohica [...] ntlworld.com - Correspondence added
On Wed Oct 21 16:13:02 2009, MJEVANS wrote: Show quoted text
> ParamTypes attribute is not available until after calling execute - this > appears contrary to the DBI spec. > > Martin
and is no longer true as in: perl -le 'use Data::Dumper;use DBI;my $h = DBI->connect; my $s = $h->prepare(q/insert into mje values(?)/);my $p = $s->{ParamTypes}; print Dumper($p), "\n"; $s->bind_param(1, 2); $p = $s->{ParamTypes}; print "bind:\n",Dumper($p), "\n"; print Dumper($s->{ParamValues});$s->execute; $p = $s->{ParamTypes};print Dumper($p), "\n";' $VAR1 = { '1' => { 'TYPE' => 0 } }; bind: $VAR1 = { '1' => { 'TYPE' => 4 } }; $VAR1 = { '1' => 2 }; $VAR1 = { '1' => { 'TYPE' => 4 } }; Not sure when this got changed but it certainly works in 1.29. Martin -- Martin J. Evans Wetherby, UK
  Tue Mar 08 04:45:26 2011 bohica [...] ntlworld.com - Status changed from 'new' to 'open'
  Tue Mar 08 04:45:58 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'resolved'
  Tue Mar 08 04:45:59 2011 bohica [...] ntlworld.com - Fixed in 1.28_5 added