I'm guessing you need to use $results->{COLUMN} as Oracle upper cases
the column names.
On Tue, Sep 02, 2003 at 10:58:54AM +0300, [EMAIL PROTECTED] wrote:
> By adding that you mentioned i recieved what i expected.
>
> I am wondering why this doesn't work if i don't add on the top of the program
> the
>
> use Data::Dumper;
>
>
>
> Quoting "Thomas A. Lowery" <[EMAIL PROTECTED]>:
>
> > 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?
> > 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?
