DBI::Simple::Recordset - Stores the results of a query executed with DBI::Simple

NAME

DBI::Simple::Recordset - Stores the results of a query executed with DBI::Simple

SYNOPSIS

  use DBI::Simple;
  $dbi = DBI::Simple->connect('mysql:hostname=localhost;database=main', 'user', 'pass');
  $rs = $dbi->query('SELECT * FROM Users');
  while($rs->has_records)
  {
          print @{$rs->row};
          $rs->move_next;
  }
  $rs->insert(name => 'jdoe', pass => 'password');
  $rs->commit;

ABSTRACT

  DBI::Simple::Recordset allows navigation of a resultset returned by the L<DBI::Simple> C<query> function.

DESCRIPTION

DBI::Simple::Recordset objects are returned by the query method of the DBI::Simple manpage. Recordsets provide the following functions:

dbh
The dbh method returns the underlying DBI database handle.

sth
The sth method returns the underlying DBI statement handle.
move_next

EXPORT

None by default.

SEE ALSO

the DBI::Simple manpage, the DBI manpage, DBD::*

COPYRIGHT AND LICENSE

Copyright 2003 by A. U. Thor

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

 DBI::Simple::Recordset - Stores the results of a query executed with DBI::Simple