Re: bind_param oddity?


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
.

Relevant Pages

  • Re: getting DBI and ODBC to work with PERL and MYSQL data source
    ... and installed DBI and DBD::ODBC perl modules. ... experience issuing a SQL query through PERL to Mysql.. ...
    (comp.lang.perl.misc)
  • DBI / DBD / MySQL installation problem
    ... I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, ... able to connect to MySQL from Perl via DBI. ... Running install for module Mysql ...
    (perl.dbi.users)
  • Re: Need help with Perl and MySQL database data load
    ... You are telling Perl that you're creating a package named ... > 'MySQL' with this line. ... I get the error message "Can't locate object method "connect" ... When I put that line, use DBI;, back in I then get an authentication ...
    (comp.lang.perl.misc)
  • Re: quer y about dbi
    ... If you plan to do a project with Perl / DBI / MySQL, ... And if you don't have yourself a good book on MySQL yet, ... Mail has the best spam protection around ...
    (perl.dbi.users)
  • Error while running DBI with Perl and MySQL
    ... I am learning Perl and using the book from apress called Beginning ... There is a section showing Perl and DBI. ... I installed MySQL and was able to build the database as per the books ... MySql 5.0 and Lastest Perl downloaded from the Perl.ORG website. ...
    (perl.dbi.users)