On 11/22/06, Garrett, Philip (MAN-Corporate) <[EMAIL PROTECTED]> wrote:
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)
Philip, Christopher, Martin,
Thanks to all of you. That was indeed the problem. See, I knew it
was something obvious I was missing. Thanks again guys.
--
Kevin.
