W3C home > Mailing lists > Public > whatwg@whatwg.org > October 2007

[whatwg] Couple comments on Database storage spec.

From: Křištof Želechovski <giecrilj@stegny.2a.pl>
Date: Sun, 7 Oct 2007 13:57:27 +0200
Message-ID: <000d01c808d9$3e966bf0$4d01010a@IBM42F76C011DF>
Maybe I am wrong but I have a feeling that the need to quote anything
programmatically means that the underlying programming language has a severe
flaw.  Quoting is a primitive method of marshalling requests for persistence
and transport; such needs are best handled behind the scenes.  If I have to
quote by hand, I am sure I am going to fail to do it right sooner or later.
Best regards

-----Original Message-----
From: whatwg-bounces@lists.whatwg.org
[mailto:whatwg-bounces at lists.whatwg.org] On Behalf Of Scott Hess
Sent: Saturday, October 06, 2007 2:03 AM
Subject: [whatwg] Couple comments on Database storage spec.

It may be worthwhile for Database to export a quote(arg) function,
which will quote the argument in the appropriate manner for use in
constructing a statement.  This is useful for cases where it is
challenging to reduce something to a static SQL statement with bind
parameters.  [A common case for this is something like "SELECT rowid
FROM t WHERE c IN (...)", and you want to replace ... with an
appropriately quoted comma-separated array.]
Received on Sunday, 7 October 2007 04:57:27 UTC

This archive was generated by hypermail 2.4.0 : Wednesday, 22 January 2020 16:58:58 UTC