DBIx-Broker
view release on metacpan or search on metacpan
748749750751752753754755756757758759760761762763764765766767768
@customers
=
$db
->select_all(
'customers'
,
"WHERE age < 30"
, 1 );
foreach
my
$customer
(
@customers
) {
"Customer $customer->{'customerID'}: "
;
"$customer->{'last_name'}, $customer->{'first_name'}"
;
}
And
if
none of the existing functions are adequate, you can
send
a raw SQL statement
if
you\'d like, by using
$db
->execute_sql(
"SELCET name FORM mailbox_tabel WHEER login = 'binkler'"
);
You may retrieve table schema information in the form of a
hashtable, whose
keys
are the field names and whose
values
are
hashrefs to the various characteristics of
each
field, such as
'Type'
,
'Key'
, etc. For convenience, the ->get_primary_key()
and ->get_auto_increments() methods have also been added.
=head1 AUTHOR
xomina@bitstream.net
( run in 0.506 second using v1.01-cache-2.11-cpan-a5abf4f5562 )