comment on

You can, however, do something along the lines of:

  my $sql = '... WHERE foo IN (' . join(',', ('?') x scalar( @values )
+) . ') ...';
[download]

in order to generate the proper placeholder-based statement that you can then pass your parameters into.

See also DBIx::PreQL.

Update: As per BrowserUK (below), in order to make use of this, you either need to prepare your query each time, cache your prepared query based on number of parameters using prepare_cached or some other method, or know that the number of parameters will be the same each and every time.

--MidLifeXis

In reply to Re: Answer: What are placeholders in DBI, and why would I want to use them? by MidLifeXis
in thread What are placeholders in DBI, and why would I want to use them? by btrott

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Don't ask to ask, just ask
	PerlMonks