W3C home > Mailing lists > Public > public-html@w3.org > November 2007

Re: SQL API -- named arguments

From: Ian Hickson <ian@hixie.ch>
Date: Thu, 1 Nov 2007 09:57:27 +0000 (UTC)
To: Jim Jewett <jimjjewett@gmail.com>
Cc: public-html@w3.org
Message-ID: <Pine.LNX.4.62.0711010956290.27205@hixie.dreamhostps.com>

On Wed, 31 Oct 2007, Jim Jewett wrote:
> 
> The API supports only positional replacements, such as
> 
> "select a, b from mytable where c='?' and d>'?'", [4, 5]
> 
> Should there be some support for named replacements, like
> 
> "select a, b from mytable where c='?val1' and d>'?val2'", {val1: 4, 
> val2: 5}
> 
> Note that this works more easily if there is some sort of limit on what 
> can replace a '?', so that it is possible to take anything next to it 
> (until whitespace or punctuation) as a name, rather than a literal.

I think we should probably wait until the next version before extending 
this API, but I agree that this would be an interesting direction to go in.

-- 
Ian Hickson               U+1047E                )\._.,--....,'``.    fL
http://ln.hixie.ch/       U+263A                /,   _.. \   _\  ;`._ ,.
Things that are impossible just take longer.   `._.-(,_..'--(,_..'`-.;.'
Received on Thursday, 1 November 2007 09:57:41 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Wednesday, 9 May 2012 00:16:09 GMT