NAME

DBI::Printf - A printf-style prepared statement

SYNOPSIS

use DBI::Printf;

my $sql = $dbh->printf(
    'select * from t where str=%s or int=%d or float=%f',
    'string',
    1,
    1.1e1);

DESCRIPTION

DBI::Printf is a printf-style prepared statement. It adds a printf method to DBI::db package.

METHODS

printf(stmt, [values])

Builds a SQL statement from given statement with placeholders and values. Following placeholders are supported.

%s - string
%d - integer
%f - floating point

AUTHOR

Copyright (c) 2007 Kazuho Oku All rights reserved.

LICENSE

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

See http://www.perl.com/perl/misc/Artistic.html