SQL::QueryBuilder::SimpleSQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries. | |
Download |
SQL::QueryBuilder::Simple Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Robert Rothenberg
- Publisher web site:
- http://search.cpan.org/~rrwo/
SQL::QueryBuilder::Simple Tags
SQL::QueryBuilder::Simple Description
SQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries. SQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries.SYNOPSIS use SQL::QueryBuilder::Simple; my $query = SQL::QueryBuilder::Simple->new( table => "MYTABLE", # from table MYTABLE fields => , # select fields FLD1, FLD2 ne => { FLD1 => -1 }, # where FLD1 not equal to -1 ); print $query->sql; # SELECT FLD1, FLD2 FROM MYTABLE WHERE FLD1? use DBI; my $dbh = DBI->connect( ... ) or die; my $sth = $dbh->prepare( $query->sql ) or die; $sth->execute( $query->bindings ) or die;This module generates simple SQL select statements and manages binding parameters, to simplify generating dynamic queries.This module will only generate SQL code. It does not validate the code, nor does it check against any database to see if table or field names are valid. Requirements: · Perl
SQL::QueryBuilder::Simple Related Software