DBI + mysql

[Raffaello Galli]

HI

I am using DBI and I tried the following code with Oracle and Mysql to
read query metadata:


$sth = $dbi->prepare($statement);
$sth->execute();
for ( $t=1; $t <= $sth->{NUM_OF_FIELDS} ; $t++ ) {
push( @H, $sth->{NAME}->[$t-1] );
}


but with Mysql $sth->{NAME} gives the following error message :

"Can't set DBI::st=HASH(0x81052a4)->{NAME}: unrecognised attribute or
invalid value"

Did someone face this problem before ? Did someone solve it ?

Raffaello

 

[Glenn Jackman]

$sth = $dbi->prepare($statement);
$sth->execute();
for ( $t=1; $t <= $sth->{NUM_OF_FIELDS} ; $t++ ) {
push( @H, $sth->{NAME}->[$t-1] );
}

but with Mysql $sth->{NAME} gives the following error message :

"Can't set DBI::st=HASH(0x81052a4)->{NAME}: unrecognised attribute or
invalid value"

Did someone face this problem before ? Did someone solve it ?

I haven't seen your error, but this is simpler:
my @H = @{ $sth->{NAME} };