SQL::Abstract::Limit

SQL::Abstract::Limit is a portable LIMIT emulation.
Download

SQL::Abstract::Limit Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Perl Artistic License
  • Price:
  • FREE
  • Publisher Name:
  • David Baird
  • Publisher web site:
  • http://search.cpan.org/~davebaird/Tree-Authz-0.03/lib/Tree/Authz.pm

SQL::Abstract::Limit Tags


SQL::Abstract::Limit Description

SQL::Abstract::Limit is a portable LIMIT emulation. SQL::Abstract::Limit is a portable LIMIT emulation.SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => 'LimitOffset' );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my $sql = SQL::Abstract::Limit->new( limit_dialect => 'My::CDBI::App' ); # or object: my $obj = My::CDBI::App->retrieve( $id ); my $sql = SQL::Abstract::Limit->new( limit_dialect => $obj ); # generate SQL: my ( $stmt, @bind ) = $sql->select( $table, @fields, %where, @order, $limit, $offset ); # Then, use these in your DBI statements my $sth = $dbh->prepare( $stmt ); $sth->execute( @bind ); # Just generate the WHERE clause (only available for some syntaxes) my ( $stmt, @bind ) = $sql->where( %where, @order, $limit, $offset ); Requirements: · Perl


SQL::Abstract::Limit Related Software

About SoftwareSea