SQL::Abstract::LimitSQL::Abstract::Limit is a portable LIMIT emulation. | |
Download |
SQL::Abstract::Limit Ranking & Summary
Advertisement
- 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