DBIx::QueryByName::Result::ScalarIterator - A scalar iterator around a statement handle
Provides an iterator-like api to a DBI statement handle that is expected to return only a single column upon each call to fetchrow_array().
DO NOT USE DIRECTLY!
my $i = new($sth);
Return a scalar iterator wrapped around this statement handle.
my $v = $i->next();
$v is the value of the single column in the entry returned by the next call to fetch_row() on the iterator's statement handle. Return undef if no entries could be fetched.
$v
Examples:
# table Jobs has only one column containing the values 1, 2 and 3. $dbh->load(session => "main", from_xml => "<queries><query name='GetJobs' params='' result='scalariterator'>SELECT * FROM Jobs</query></queries>", ); # $i is a ScalarIterator my $i = $dbh->GetJobs(); print $i->next."\n"; # prints '1' print $i->next."\n"; # prints '2' print $i->next."\n"; # prints '3' # the next '$i->next' returns undef
To install DBIx::QueryByName, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::QueryByName
CPAN shell
perl -MCPAN -e shell install DBIx::QueryByName
For more information on module installation, please visit the detailed CPAN module installation guide.