Agree as well with :1. The ?1 is used in SQLite and possibly a couple others. There is also $1 (how PostgreSQL does it), which I forgot to mention.
Let's stick with :1 unless someone else objects. :) -Eric On Mon, Oct 19, 2009 at 11:48:04PM -0700, Monty Taylor wrote: > Kristian Nielsen wrote: > > Eric Day <[email protected]> writes: > > > >> Thanks to all who responded with the valuable feedback. It sounds > >> like we need to support '?' for other APIs, and I think supporting > >> both numeric and string IDs will be trivial on top of this. String > > > >> 1: INSERT INTO foo VALUES(?, ?1) > > > > This looks terrible with respect to confusion about whether ?1 is an > > anonymous > > placeholder followed by a digit, or a number placeholder. Not that the issue > > could not be resolved, but why introduce the complication in the first > > place? > > Agree. Looks more like a syntax error to me. > > >> 2: INSERT INTO foo VALUES(?, :1) > > > > This seems the obvious choice to me ... > > Agree. > > ++ for :1 and not ?1 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
