On 12/10/07, Jamie Bullock <jamie@postlude.co.uk> wrote:
PREPARE uses the '$' character as its placeholder identifier, and '$1'
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.
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.
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