in reply to Re^2: DBI query where table name is a variable
in thread DBI query where table name is a variable

Hmmmm... Take care when using placeholders as tablenames; you'll better check if that works with your DB and should avoid it even if it works if portability matters.

The DBI documentation mentions that
---
With most drivers, placeholders can't be used for any element of a sta +tement that would prevent the database server from validating the sta +tement and creating a query execution plan for it. For example: "SELECT name, age FROM ?" # wrong (will probably fail +) "SELECT name, ? FROM people" # wrong (but may not 'fail' +)

Krambambuli
---
enjoying Mark Jason Dominus' Higher-Order Perl