DBIx::QueryCursor - Database cursor handler
use DBIx::QueryCursor; my $cursor = new DBIx::QueryCursor( connection => $connection, sql => "SELECT * FROM emp WHERE ename = ?" ); my $result_set = $cursor->execute(['Smith']); if($cursor->fetch()) { $ename = result_set->{ENAME}; ... do some stuff } or use DBIx::Connection; my $cursor = $connection->query_cursor( sql => "SELECT * FROM emp WHERE ename = ?" );
Class that represents database cursor.
Fetch resultset.
Number of rows retrieved since last execution.
Function return list of column from current cursor
Executes statements, takes bind parameters as ARRAY ref, optionaly resul set as reference(HASH, SCALAR, ARRAY) Returns result set.
Returns the cursor itarator, on each iteration database error is checked. For instance sub query returned more then error exception is capture here.
Move cursor to next result. Returns true if a row was fetched or false if no more results exist.
Signals that the cursor will not be used again.
The DBIx::QueryCursor module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.
DBIx::Connection DBIx::SQLHandler.
Adrian Witas, adrian@webapp.strefa.pl
To install DBIx::Connection, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Connection
CPAN shell
perl -MCPAN -e shell install DBIx::Connection
For more information on module installation, please visit the detailed CPAN module installation guide.