Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: DBI query where table name is a variable

by duff (Parson)
on Oct 22, 2007 at 15:41 UTC ( #646470=note: print w/replies, xml ) Need Help??

in reply to DBI query where table name is a variable

Did you set $table before you called $dbh->prepare? Are you sure you set it correctly? There's a way to get DBI to tell you exactly what it sent to the SQL processor but I forget what it is. Perhaps another kind monk can enlighten you so you can see what the SQL processor sees.

Replies are listed 'Best First'.
Re^2: DBI query where table name is a variable
by Fletch (Bishop) on Oct 22, 2007 at 16:56 UTC

    Usually if you call $sth->trace( 2 ) (alternately call trace on your $dbh to enable tracing for all statement handles subsequently created) you should get a glimpse at the SQL that's being sent to the backend.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://646470]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2022-08-08 01:05 GMT
Find Nodes?
    Voting Booth?

    No recent polls found