Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: Using Data::Dumper on a MySQL statement handle

by umasuresh (Hermit)
on Nov 10, 2010 at 17:04 UTC ( [id://870625]=note: print w/replies, xml ) Need Help??


in reply to Using Data::Dumper on a MySQL statement handle

You have to execute subsequent steps before dumping the results
http://openwetware.org/wiki/Perl/DBI.
  • Comment on Re: Using Data::Dumper on a MySQL statement handle

Replies are listed 'Best First'.
Re^2: Using Data::Dumper on a MySQL statement handle
by Anonymous Monk on Nov 10, 2010 at 17:14 UTC
    That's a great link! It isn't the results I'm concerned with, since they are just fine. It's the actual SQL statement that is being sent that I'm interested in checking. I just need to be able to check the SQL statement from the $sth object to verify that the subclassing was successful.

      I may be misunderstanding but can't you just look at the Statement attribute?

        mje, that worked great!
        print $dbh->{Statement}
        is your friend.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2024-04-16 16:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found