Name
sqlSelectMany — prepares and executes a SQL statement, returning a DBI
statement handle
Synopsis
my $sth = $slashdb->sqlSelectMany($select); my $sth = $slashdb->sqlSelectMany($select, $from); my $sth = $slashdb->sqlSelectMany($select, $from, $where); my $sth = $slashdb->sqlSelectMany($select, $from, $where, $other);
sqlSelectMany
provides access to the underlying DBI interface. It constructs a SQL statement from its
parameters, returning a statement handle which can be used to retrieve the
results. It takes the same parameters and handles errors in the same way as
sqlSelect
.
Example
my $sth = $slashdb->sqlSelectMany('nickname, realemail', 'users', 'seclev > 100'); while (my $row = $sth->fetchrow_hashref) { print "Author: $row->{nickname}, email: $row->{realemail}\n"; }
Get Running Weblogs with Slash now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.