11 Dec
2007
11 Dec
'07
9:59 a.m.
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.
Jamie
--
www.postlude.co.uk