Absolutely easy yet fast and powerful SQL access.
This module wraps the DBI prepare/bind/execute calls into a single "sql_exec" call, complete with statement caching, so you get the efficiency of prepare, the safety of using placeholders and the speed of bound result values in a simple call. Example:
my $st = sql_exec \my ($id, $name),
"select id, name from db where name like %",
"pfx%";
while ($st->fetch) {
print "$id $name\n";
}
Contact for this page: Marc Lehmann <schmorpforge@schmorp.de>.