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?
