Re: DBI query where table name is a variable


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

Re: DBI query where table name is a variable

by duff (Parson)

on Oct 22, 2007 at 15:41 UTC ( [id://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.

duff

Comment on Re: DBI query where table name is a variable Select or Download Code

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.	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://646470]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others romping around the Monastery: (4)

As of 2024-04-24 20:08 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found