<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<br><div><div>On Dec 10, 2007, at 2:19 PM, Mike McGonagle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><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></blockquote><div><br class="webkit-block-placeholder"></div><div>It seems many things use the "?" alone as the unnamed placeholder, but I only saw MySQL using ?name for named placeholders. It does seem like a nicer syntax rather than using a different character. Perhaps, we should follow pgsql and use "$" and "$name", since "$" is already a marker for replacement vars in Pd. I suppose that could get confusing in something like:</div><div><br class="webkit-block-placeholder"></div><div>SELECT id, ABS(($duration - $1)/$2) AS error FROM datatable ORDER BY error LIMIT 1</div><div><br class="webkit-block-placeholder"></div><div>.hc</div><br><blockquote type="cite"><div><div> </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><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="mailto:PD-list@iem.at">PD-list@iem.at</a> mailing list</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">UNSUBSCRIBE and account-management -> <a href="http://lists.puredata.info/listinfo/pd-list">http://lists.puredata.info/listinfo/pd-list</a></div> </blockquote></div><br><div> <span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><br class="Apple-interchange-newline"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div><br></div><div>----------------------------------------------------------------------------</div><div><br></div><div>If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of everyone, and the receiver cannot dispossess himself of it. - Thomas Jefferson</div><br class="Apple-interchange-newline"></span></span> </div><br></body></html>