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

Reply via email to