Re: DBI Format Question

[jeffa]

in reply to DBI Format Question

You cannot use placeholders for table names like that. You'll have to instead interpolate inside the string. It's ok, though, you are not dealing with user input here.

$dbh->prepare( "select stuff from $table");

Having to use table names like that is a challenge too. I would look into renaming those tables and removing the dashes if that is an option and a viable one at that. Good luck! :)

[ikegami]

You can't use placeholders because table names must be known when the query is prepared. That leaves using a quoting function.

my $q_table = $dbh->quote_identifier($table);
$dbh->prepare("select stuff from $q_table");