dbix::class::storage::dbi::cursor(3pm) [debian man page]
DBIx::Class::Storage::DBI::Cursor(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Cursor(3pm)NAME
DBIx::Class::Storage::DBI::Cursor - Object representing a query cursor on a resultset.
SYNOPSIS
my $cursor = $schema->resultset('CD')->cursor();
my $first_cd = $cursor->next;
DESCRIPTION
A Cursor represents a query cursor on a DBIx::Class::ResultSet object. It allows for traversing the result set with "next", retrieving all
results with "all" and resetting the cursor with "reset".
Usually, you would use the cursor methods built into DBIx::Class::ResultSet to traverse it. See "next" in DBIx::Class::ResultSet, "reset"
in DBIx::Class::ResultSet and "all" in DBIx::Class::ResultSet for more information.
METHODS
new
Returns a new DBIx::Class::Storage::DBI::Cursor object.
next
Arguments: none
Return Value: @row_columns
Advances the cursor to the next row and returns an array of column values (the result of "fetchrow_array" in DBI method).
all
Arguments: none
Return Value: @row_columns+
Returns a list of arrayrefs of column values for all rows in the DBIx::Class::ResultSet.
reset
Resets the cursor to the beginning of the DBIx::Class::ResultSet.
perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::Cursor(3pm)
Check Out this Related Man Page
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::CuUser(Contributed Perl DocumDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)NAME
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor - Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO
DESCRIPTION
This class is for removing trailing "NULL"s from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO.
You probably don't want to be here, see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server
driver for ADO and DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class.
Unfortunately when using DBD::ADO, binary data comes back padded with trailing "NULL"s and GUIDs come back wrapped in braces, the purpose
of this class is to remove the "NULL"s and braces. DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server sets cursor_class to this class by
default. It is overridable via your connect_info.
You can use DBIx::Class::Cursor::Cached safely with this class and not lose the binary data normalizing functionality, ::Cursor::Cached
uses the underlying class data for the inner cursor class.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)
Hi there, I wonder if somebody could help me out, i have a written a DBI perl snippet using fetchall_arrayref() that i want to use to populate a simple standard array with the results of a query
#!/usr/bin/perl -w
use DBI;
my $dbh =... (3 Replies)
I am writing a cursor to select values from 3 tables. I want to store these values in a txt file which I will be sending via ftp. I am able to store the results of simple select queries to the txt file. but I am not sure how to store the values when using a cursor. I have given the sql query below.... (1 Reply)