<br><br><div><span class="gmail_quote">On 12/10/07, <b class="gmail_sendername">Jamie Bullock</b> <<a href="mailto:jamie@postlude.co.uk">jamie@postlude.co.uk</a>> wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">
PREPARE uses the '$' character as its placeholder identifier, and '$1'</blockquote><div><br class="webkit-block-placeholder"></div><div>Jamie, after thinking about this, I don't think we should worry about the specifics of the characters that we use, as long as we can agree on what gets entered into a PD message box, the specific instance of the external ('sqlite', 'psql', etc.) can handle the conversion to what the specific database uses.
</div><div><br class="webkit-block-placeholder"></div><div>From what I have seen on this thread, is it right that the '?' syntax does NOT have an identifier following it? I think it would be very helpful if we use identifiers in the SQL if only to make the binding to the proper datatypes easier, as per my last email.
</div><div><br> </div></div>Mike<div><br>-- <br>Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal.<br>—Yehudi Menuhin (1916–1999), musician
</div>