Folks above in thread already mentioned how to go about doing do what you are looking to do - by throwing a variable into the WHERE clause for the dynamic changing of the sql statement to the left of the '=' sign, and then your '?' to the right of the '=' sign would stay the same.

Would add on to this discussion by commenting that the reason that you can use the '?' to the right of the '=' is that you are using the '?' as a placeholder to bind the value if you are going to use the statement multiple times in your script for example. Most newer database products support this and by doing it you don't have to incur the overhead of executing the execution plan each time the statement is run.

Which brings me to a question which interests me which your point gets me wondering about...

In a way it seems as though using a variable in the creation a sql-DBI prepare statement such as in the example in this thread is an oxymoron. Can you get away with not incuring the overhead of re-executing the execution plan each time even though you are changing your actual sql statement via a variable which alters the statement itself?

I looked into the Perldoc DBI module documentation documentation and around a bit and couldn't find the answer to the question.

Does anyone know the answer to this? peppiv's initial question got me wondering (nothing like posting a question back to a question)...

nandeya

In reply to Re: Passing a value into a WHERE clause by nandeya
in thread Passing a value into a WHERE clause by peppiv

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.