---------- Forwarded message ---------- From: Mike McGonagle <[EMAIL PROTECTED]> Date: Dec 9, 2007 4:21 PM Subject: Re: [PD] [psql] object hand-holding To: Mathieu Bouchard <[EMAIL PROTECTED]>
On 12/7/07, Mathieu Bouchard <[EMAIL PROTECTED]> wrote: > > On Fri, 7 Dec 2007, Hans-Christoph Steiner wrote: > > > That is done by sending the [submit( message to the hot inlet. Or do > you > > mean having multiple SQL calls separated by semi-colons? If you wanted > to > > add semicolons, there would have to be a special message, I think we > could > > just reuse the "addsemi", "addcomma", "adddollar" messages from message > > boxes. > > The only SQL interface I'd really be happy to use (if I had to use SQL) is > > something using placeholders, sort of like [expr], but perhaps written in > the usual SQL style: > > [sql select * from candies where flavour=? and colour=?] 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. 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'. > you wouldn't modify the statement any more than you modify an [expr] at > runtime. this allows the statement to be precompiled by the server. you > could still allow runtime change but perhaps it would get messy with > multiple inlets, so let's assume for now that it is not supported. This is why I thought of this in the first place. You generally don't modify the SQL, except to insert data. Mike -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician
_______________________________________________ [email protected] mailing list UNSUBSCRIBE and account-management -> http://lists.puredata.info/listinfo/pd-list
