<br><br><div class="gmail_quote">On Tue, Jan 26, 2010 at 10:42 PM, Peter Rabbitson <span dir="ltr"><<a href="mailto:rabbit%2Bdbic@rabbit.us">rabbit+dbic@rabbit.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">Drew Taylor wrote:<br>
> I'm not a DBIC expert, but I don't think so. The [...] construct creates<br>
> an arrayref, so the leading '\' would just create a reference to a<br>
> reference which is probably NOT what you want. :-) Perhaps you're<br>
> thinking about passing a scalar ref to put raw SQL into the query, ie.<br>
> \"some sql"?<br>
<br>
</div>This is exactly what you want. Please refer to the fine docs of SQL::Abstract.<br>
In short:<br>
<br>
to supply a string of raw sql:<br>
<br>
\$sql<br>
<br>
to supply a string of raw sql bundled with bind values for placeholders:<br>
<br>
\[ $sql, @list_of_bindvals ]<br>
</blockquote><div> <br>Thanks for clearing that up! I've never used the second version, so now I've learned something new. :-) <br><br>Drew</div></div><br>