AW: Perl DBI error

2009-07-07 Thread Thomas Bätzler
Dave Tang asked: > I am having a problem with binding a variable when executing on a DBI > object. [...] "You can only reliably bind values, not field or table names. Database that plan query execution won't accept this, because they need table and field names to make their query execution p

Perl DBI error

2009-07-07 Thread Dave Tang
Hi everybody, I am having a problem with binding a variable when executing on a DBI object. The code goes: #!/usr/bin/perl use warnings; use strict; use DBI; #DBI variables my $database = 'databaseName'; my $hostname = 'localhost'; my $dsn = "DBI:mysql:database=$database;host=$hostname"; my