Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBI and placeholders, see resulting query?

by mje (Curate)
on May 27, 2014 at 09:35 UTC ( [id://1087504]=note: print w/replies, xml ) Need Help??


in reply to DBI and placeholders, see resulting query?

Neither DBI, the DBD or even the driver actually produce some SQL with your parameters magically inserted. Mostly the SQL is passed to the database with parameter markers and parsed then the parameters are sent seperately.

You can find your parameter values from ParamValues. You might want to take a look at DBIx::Log4perl or DBIx::LogAny as both of those can output this info and even if you don't use them you can see how they do it.

  • Comment on Re: DBI and placeholders, see resulting query?

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (1)
As of 2026-05-10 18:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.