Hi All! I like named variables, and I would then use the format invented by Oracle (also supporte by for example PDO in PHP):
:name (Colon, immediatelely followed by the name.) But I think you would also support the question mark parameter style (i mean the one supported now by MySQL as that is widely used in both ODBC and JDBC regards, Roland On Tue, Oct 13, 2009 at 9:42 AM, Eric Day <[email protected]> wrote: > Hi! > > We've decided to add the prepared statement API sooner than later, > and I've been looking into various ways of mapping variables in. There > are simple '?' with order of appearance determining order into the > array of vars, there are '$1', '$2', ... which would allow you to > repeat or do things out of order. Or the SQLite method of '?nnn' or > ':aaa' and also allow identifies. > > What are folks thoughts on PS APIs? Anything they really love or hate? > > We're also thinking of restricting vars to strings for now, but > possibly simple INT types. Other types could still be given as vars, > but they'd just be passed in as strings. > > Thanks! > -Eric > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL", http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470484322.html _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
