Kevin Spencer wrote: > Hi guys, > > I'm sure I'm missing something *very* obvious but this one has me > scratching my head. Using DBI 1.52, DBD::mysql 3.0007, Perl 5.8.8, > MySQL 5.0.18. > [snip] > > my $SQL = <<EOSQL; > select count(*) from ? > where TRXSTATUS = ? > and (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(TRXTIMESTAMP)) < ? > EOSQL
You can't bind a table name -- binding is only for "value" types. This is attempting to execute: select count(*) from 'CCHISTORY' ... (which won't run in mysql either) Regards, Philip
