On Mon, Sep 01, 2003 at 11:58:37PM -0700, Dave Anderson wrote:
> Sorry for the spam, slipped key... again:
>
> After much googling I found the following line of code:
>
> %hash = @{$dbh->selectcol_arrayref($sql,{ Columns=>[1,2]})}
>
> at http://archive.develooper.com/[EMAIL PROTECTED]/msg00039.html
>
> This approach does not seem to work either. If I change %hsh to %hash
> below, then a useful hash is returned from the dbmagic() function and
> passed successfully to buildPopup(). I seem to be unable to load a hash
> using selectcol_arrayref(). I found Perl 5.8 Source and will attempt to
> compile it with threading enabled, with -Uusemymalloc, then rebuild DBI
> & DBD::Oracle.
Whatever problem you're having it almost certainly unrelated to DBD::Oracle.
Why not start by using Data::Dumper to dump the return value of selectcol_arrayref?
use Data::Dumper;
$data = $dbh->selectcol_arrayref($sql,{ Columns=>[1,2]});
print Dumper($data);
If the data is wrong then it would seem to be a DBI issue, otherwise there's
a problem with your code.
Tim.
