SQLayer 1.1
Sponsored Links
SQLayer 1.1 Ranking & Summary
File size:
0.003 MB
Platform:
Any Platform
License:
Perl Artistic License
Price:
Downloads:
828
Date added:
2007-07-18
SQLayer 1.1 description
SQLayer is a Perl interface to DB.
use SQLayer;
my $D = SQLayer -> new(database => DBI:mysql:database=phorum;host=localhost;port=3306, user => user, passowrd => somepass);
my $PAllRowsArrayRef = $D -> all_rows("SELECT a, b FROM dum"); # pointer to array
my @AOneColumnArray = $D -> column("SELECT a FROM dum"); # array
$D -> commit; # is equal to $D -> proc("COMMIT");
my $NConnectStatus = $D -> connect_status; # returns 1 if connected
$D -> DEBUG(1); # warn query only
$D -> DEBUG($n); # set trace level to $n-1
$D -> enable_transactions; # enable transactions if possible
$D -> errstr; # returns error code
my %HHashNameById = $D -> hash_all("SELECT id, name FROM dum"); #
my $PHashOneByFieldsNameRef = $D -> hash_row("SELECT a, b, c FROM dum WHERE id = 1"); # pointer to hash
my %HHashOneByFieldsName = $D -> hash_var("SELECT a, b, c FROM dum WHERE id = 1"); # hash
$D -> nodebug; # No warn query and clear tracing
$NAffectedRowsNum = $D -> proc("DELETE FROM dum WHERE a = b"); # affected rows
my @AOneRowArray = $D -> row("SELECT a, b, c FROM dum WHERE id = 1"); # array
my $NVvalue = $D -> row("SELECT a FROM dum WHERE id = 1 "); # one value
my $PRowOfHashRef = $D -> row_hash("SELECT a, b, c FROM dum"); # pointer to array of hashes
$SQuoted = $D -> quote($SSomeVar); # same as DBI method
use SQLayer;
my $D = SQLayer -> new(database => DBI:mysql:database=phorum;host=localhost;port=3306, user => user, passowrd => somepass);
my $PAllRowsArrayRef = $D -> all_rows("SELECT a, b FROM dum"); # pointer to array
my @AOneColumnArray = $D -> column("SELECT a FROM dum"); # array
$D -> commit; # is equal to $D -> proc("COMMIT");
my $NConnectStatus = $D -> connect_status; # returns 1 if connected
$D -> DEBUG(1); # warn query only
$D -> DEBUG($n); # set trace level to $n-1
$D -> enable_transactions; # enable transactions if possible
$D -> errstr; # returns error code
my %HHashNameById = $D -> hash_all("SELECT id, name FROM dum"); #
my $PHashOneByFieldsNameRef = $D -> hash_row("SELECT a, b, c FROM dum WHERE id = 1"); # pointer to hash
my %HHashOneByFieldsName = $D -> hash_var("SELECT a, b, c FROM dum WHERE id = 1"); # hash
$D -> nodebug; # No warn query and clear tracing
$NAffectedRowsNum = $D -> proc("DELETE FROM dum WHERE a = b"); # affected rows
my @AOneRowArray = $D -> row("SELECT a, b, c FROM dum WHERE id = 1"); # array
my $NVvalue = $D -> row("SELECT a FROM dum WHERE id = 1 "); # one value
my $PRowOfHashRef = $D -> row_hash("SELECT a, b, c FROM dum"); # pointer to array of hashes
$SQuoted = $D -> quote($SSomeVar); # same as DBI method
SQLayer 1.1 Screenshot
SQLayer 1.1 Keywords
SQLayer
SELECT
SQLayer 1.1
DB
Perl Interface
interface to
d
Dum
hash
1
b
id
SQLayer 1.1
Libraries
Programming
Bookmark SQLayer 1.1
SQLayer 1.1 Copyright
WareSeeker periodically updates pricing and software information of SQLayer 1.1 full version from the publisher, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of SQLayer 1.1 Edition. Download links are directly from our publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed
Featured Software
Want to place your software product here?
Please contact us for consideration.
Contact WareSeeker.com
Related Information
selective service registration
holiday inn select
select this link
selective service
natural selection
what is natural selection
selecta
perl interface wow
select a seat
select comfort
perl interfaces
select personnel
selectcomfort
select staffing
select start
gender selection
select equipment
select portfolio servicing
Related Software
Msql is a Perl interface to the mSQL and mysql databases. Free Download
nsmhash is an aolserver module that implements an interface to the mhash library (libmhash). Free Download
DB_File is a Perl5 access to Berkeley DB version 1.x. Free Download
PApp::SQL is an absolutely easy yet fast and powerful sql access. Free Download
User::Utmp is a Perl access to utmp- and utmpx-style databases. Free Download
Sun::Solaris::Ucred is a Perl interface to User Credentials. Free Download
Sys::PortIO is a Perl module to perform direct port I/O from Perl. Free Download
RAS::PortMaster.pm is a Perl Interface to Livingston PortMaster 2. Free Download
Latest Software
Popular Software
Favourite Software
