sybperl-l Archive

From: Tim Bunce <Tim dot Bunce at pobox dot com>
Subject: Re: $sth->{NAME} doesn't work
Date: Jan 15 2004 11:53AM

On Thu, Jan 15, 2004 at 10:50:07AM -0000, Avis, Ed wrote:
> Tim Bunce wrote:
> 
> >The DBI doc says:
> >
> >: Note that some drivers cannot provide valid values for some or all of
> >: these attributes until after C<$sth-Eexecute> has been called.
> >
> >A statement handle should always have NAME, TYPE, NULLABLE etc
> >attributes.  It should never be an error to ask for them. But the
> >value returned may be undef, for example, if the statement has not been
> >executed, the execute failed, or it's not a select statement.
> 
> If RaiseError is set, then shouldn't accessing one of these when it is
> not available throw an exception rather than giving undef?

I don't think so. It's not an error, it's just unavailable
(although you could argue it either way).

Tim.