in reply to Looking for a simpler DBI solution.

$dbh->do() does the execute() for you already. That's the point of using do() :). You could do this: 
$dbh->do('INSERT INTO ... (?,....?)', undef, @_);

[download]
and skip the execute().

Replies are listed 'Best First'.
Re: Re: Looking for a simpler DBI solution.
by kwoff (Friar) on Nov 01, 2001 at 23:40 UTC
    Also, if you're starting out doing web application development, read "MySQL and Perl for the Web". That site contains a slick WebDB.pm that does some input validation based on the MySQL table "metadata". (read the book for explanation how to use it :) Actually he (Paul DuBois) has a really excellent book called "MySQL" (I used it to figure out how to do MySQL stuff from the Apache C API, which made me feel special, hehe).
[reply]
      Kwoff, if you find some spare time I would appreciate if you could write a review for the Book Reviews section.

      Hanamaki
[reply]
[reply]

In Section Seekers of Perl Wisdom