Until I read the answer from roboticus I didn't even think you might have thought a driver replaced the placeholders with your parameters in the SQL string. The purpose of preparing a statement with parameters is that the database can parse the SQL once, may be compile it, build an execution plan, optimise it, cache it etc as in most cases the parameters won't affect this. Drivers generally pass the SQL string including placeholders to the database engine then pass the parameters separately afterwards. So long as you are using prepare/execute (and not do) you can access the SQL you passed to prepare with the Statement attribute and the parameters via the ParamValues, ParamTypes and ParamArrays.

In reply to Re: getting the sql of a parameterised query by mje
in thread getting the sql of a parameterised query by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.