On Dec 12, 2007, at 11:52 AM, Jamie Bullock wrote: > > On Tue, 2007-12-11 at 15:48 -0500, Hans-Christoph Steiner wrote: >> On Dec 11, 2007, at 3:59 AM, Jamie Bullock wrote: >> >>> >>> On Mon, 2007-12-10 at 18:07 -0500, Hans-Christoph Steiner wrote: >>>> >>> >>>> 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: >>>> >>>> >>>> SELECT id, ABS(($duration - $1)/$2) AS error FROM datatable >>>> ORDER BY >>>> error LIMIT 1 >>>> >>> >>> I vote that we use "?" as a placeholder, and only support unnamed >>> placeholders. We can use this to convert to whatever the db-specific >>> placeholder system is inside the external. >> >> I am ok with using ?name for placeholders, but I think we should also >> support the plain ? with the list input. I am fine if that happens >> later tho. I'd like to get something working soon, we've done a lot >> of talking :). >> > > I agree about getting on with it. However, I probably won't be able to > commit any coding time to [psql] until after Christmas. This might be > sensible though - I suggest we get the interface to one of the objects > 'right' first and then copy this in the others. Mike seems to be > pretty > active on the SQLite one, so I suggest we let that take the lead and > follow that.
Sounds like a plan :) .hc ------------------------------------------------------------------------ ---- Looking at things from a more basic level, you can come up with a more direct solution... It may sound small in theory, but it in practice, it can change entire economies. - Amy Smith _______________________________________________ [email protected] mailing list UNSUBSCRIBE and account-management -> http://lists.puredata.info/listinfo/pd-list
