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.
.....
Now, because I want use use placeholders instead, I attempt the
following:
my $SQL = <<EOSQL;
select count(*) from ?
where TRXSTATUS = ?
and (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(TRXTIMESTAMP)) < ?
EOSQL
Anyone see an obvious error in my code that I'm overlooking?
Thanks.
--
Kevin.
I'm pretty sure that you can't use bind variables in place of table
names. Certainly true of Oracle stuff.
Martin