NAME

DBIx::QueryByName::Result::ScalarIterator - A scalar iterator around a statement handle

DESCRIPTION

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!

INTERFACE

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.

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