Re: DBI prepare and fetch



soup_or_power@xxxxxxxxx wrote:
> Hi
> What does DBI's prepare do?

At a high level? It prepares your statement. At a low level?
Whatever DBD makes it do.

> Will it flag any errors?

That depends. In Oracle, it will flag some errors. In Mysql,
I don't think it will even do that.

> Also what does
> fetch do. I tried "perldoc DBI" but couldn't find the answers there.

Fetch is an alias for fetchrow_arrayref. As I just discovered, this fact
is surprisingly very poorly documented in DBI.

"fetchrow_arrayref"
$ary_ref = $sth->fetchrow_arrayref;
$ary_ref = $sth->fetch; # alias

That appears to be it. There should be an entry that says:
"fetch"
An alias for fetchrow_arrayref.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
.



Relevant Pages

  • DBI prepare and fetch
    ... Will it flag any errors? ... fetch do. ... I tried "perldoc DBI" but couldn't find the answers there. ... Prev by Date: ...
    (comp.lang.perl.misc)
  • fetch: Resume errors, help!
    ... Living in South Africa internet access is not what it could be, ... When fetch tries to resume from an ftp site that does not support resuming (or ... See below for my patch. ... problem is that how to handle the -R flag. ...
    (freebsd-hackers)
  • Re: DBI prepare and fetch
    ... Will it flag any errors? ... Read about the fetch_* methods. ... Sinan Unur ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: Tell portupgrade to use passive ftp
    ... tell portupgrade to pass the -p flag to fetch? ... and configure fetch to use whatever that supports. ... mean switching fetch from passive to active ftp. ...
    (freebsd-questions)
  • Re: how to get mailbox size in bytes?
    ... Is there a command or flag to fetch this info. ... I want to avoid calling ... FETCH to get 'size' attribute of the message individually. ... Mailbox size here refers to the number of messages in the mailbox, ...
    (comp.mail.imap)