develooper Front page | perl.dbi.dev | Postings from June 2011

Re: Is it ever legal (should be supported) to issue a non select in selectall_arrayref?

Thread Previous | Thread Next
From:
David Nicol
Date:
June 29, 2011 08:48
Subject:
Re: Is it ever legal (should be supported) to issue a non select in selectall_arrayref?
Message ID:
BANLkTikg2+dCe4z=ER3kf+ORi3YUji5-2g@mail.gmail.com
Show, don't tell. Also, it's a little shorter now.


BEGIN THING TO INSERT
=head3 On use of non-C<SELECT> SQL in C<select*_*> methods

While some drivers support statements other than C<SELECT> in the
above-listed convenience functions, others do not: driver support for this
facility is not defined by the DBI interface standard, and the C<do>
method is provided for non-C<SELECT> statements.

When you really don't know if the statement you have in a variable is
going to be a C<SELECT>  or not, you may unroll the process into
C<prepare>, C<execute>, and  C<eval {fetch*}>.
END THING TO INSERT

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About