<br><br>---------- Forwarded message ----------<br><span class="gmail_quote">From: <b class="gmail_sendername">Mike McGonagle</b> <<a href="mailto:mjmogo@gmail.com">mjmogo@gmail.com</a>><br>Date: Dec 9, 2007 4:21 PM<br>
Subject: Re: [PD] [psql] object hand-holding<br>To: Mathieu Bouchard <<a href="mailto:matju@artengine.ca">matju@artengine.ca</a>><br><br></span><br><br><div><span class="q"><span class="gmail_quote">On 12/7/07, <b class="gmail_sendername">
Mathieu Bouchard</b> <<a href="mailto:matju@artengine.ca" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">matju@artengine.ca</a>> wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">
On Fri, 7 Dec 2007, Hans-Christoph Steiner wrote:<br><br>> That is done by sending the [submit( message to the hot inlet. Or do you<br>> mean having multiple SQL calls separated by semi-colons? If you wanted to<br>
> add semicolons, there would have to be a special message, I think we could<br>> just reuse the "addsemi", "addcomma", "adddollar" messages from message<br>> boxes.<br><br>The only SQL interface I'd really be happy to use (if I had to use SQL) is
<br>something using placeholders, sort of like [expr], but perhaps written in<br>the usual SQL style:<br><br>[sql select * from candies where flavour=? and colour=?]</blockquote><div><br> </div>
<div><br> </div></span><div>I am actually considering going back to this idea, as I can't seem to figure out why my current version of [sqlite] is crashing. Hans said that PD generally doesn't crash, and for other externals that I have written, I was able to track down the bugs because it was crashing within my external. Here it is crashing while executing PD code, and that tells me that PD DOES crash.
</div><div><br> </div><div>I wish there were some sort of tutorial on troubleshooting problems like this, mostly because I don't really know where to start with something like 'gdb'.
</div><span class="q"><div><br> </div><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">you wouldn't modify the statement any more than you modify an [expr] at
<br>runtime. this allows the statement to be precompiled by the server. you
<br>could still allow runtime change but perhaps it would get messy with<br>multiple inlets, so let's assume for now that it is not supported.</blockquote><div><br> </div></span><div>This is why I thought of this in the first place. You generally don't modify the SQL, except to insert data.
</div><div> </div></div><div>Mike</div><div><span class="e" id="q_116c0ffced599eda_5"><div><br> </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
</span></div><br clear="all"><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