Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^2: DBI Format Question

by ikegami (Pope)
on Aug 03, 2010 at 18:50 UTC ( #852718=note: print w/replies, xml ) Need Help??

in reply to Re: DBI Format Question
in thread DBI Format Question

You can't use placeholders because table names must be known when the query is prepared. That leaves using a quoting function.
my $q_table = $dbh->quote_identifier($table); $dbh->prepare("select stuff from $q_table");

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://852718]
[james28909]: i need to convert those @weekdays to an numerical date based off of scalar localtime
[james28909]: i have thught about this and though about it lol
[james28909]: also remember, that if 'Today' is may 1, then Yesterday is not may 31 lol
[james28909]: theoretically speaking ofcourse
[james28909]: so if you subtracting as you loop, be aware that you will eventually be subtracting into a past month, or year <.<
[james28909]: dontcha love it!

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2017-04-29 03:53 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (531 votes). Check out past polls.