Re: fetchrow_hashref doesn't work for me!

[Ian Harisay]

I work with both MySQL and Oracle.  As a standard practice I will write 
fetchrow_hashref('NAME_lc').  This forces all column names to be lower 
case. 

Thomas A. Lowery wrote:

On Mon, Sep 01, 2003 at 09:38:04PM +0300, [EMAIL PROTECTED] wrote:
 

The case of the column is correct.
This does work when i use $results=$sth->fetchrow_arrayref;
only $results=$sth->fetchrow_hashref has the problem
I use dbd::oracle to connect with my database.
Does it play any role?
   

Add this to your script:

use Data::Dumper;

(after the fetchrow_hashref)
print Dumper($results);
Does anything print?

Tom

p.s. include the dbi-users list in your response please.  The replies that help
you now may help another in the future.
 

Quoting "Thomas A. Lowery" <[EMAIL PROTECTED]>:

   

On Mon, Sep 01, 2003 at 09:04:11PM +0300, [EMAIL PROTECTED] wrote:
     

I have a simple query
----------------------------------
$sth=$dbh->prepare("SELECT column FROM table WHERE columnid=1");
       

Is there data in table "table" for columnid 1?

     

$sth->execute();

$results=$sth->fetchrow_hashref;

print $results->{column};
       

Is the case of column correct?

     

I cannot see the $results->{column}.

Why does this happen?
       

Error checking?  Trace?