On Wed, Feb 22, 2012 at 11:14 PM, Petite Abeille
wrote:
> http://www.sqlite.org/lang_keywords.html
>
@sqlite3 committers: there's a minor error on that page: is says "There are
three ways of quoting..." and then goes on to show four ways.
--
- stephan beal
http://wanderinghorse.net/home/ste
On Feb 22, 2012, at 10:21 PM, Pete wrote:
> I try to access that column in any way, I get an error, no matter whether I
> specify the column name with no quotes, single quotes or double quotes
For the record:
http://www.sqlite.org/lang_keywords.html
> For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1"
> (which I'd expect). If I try 'SELECT "CoL 1" FROM...", I get and error "no
> such column "Col1" - notice there is no space in the column name listed in
> the error message".
>
Are you escaping the quotes for whatever langu
On 2/22/2012 4:21 PM, Pete wrote:
I seem to have stumbled upon what looks like a bug in SQLite. I
accidentally created a column in a table that included a space in its
name,eg "Col 1". The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an err
On Wed, Feb 22, 2012 at 10:21 PM, Pete wrote:
> I seem to have stumbled upon what looks like a bug in SQLite. I
> accidentally created a column in a table that included a space in its
> name,eg "Col 1". The CREATE TABLE command accepted without an error but if
> I try to access that column in a
I seem to have stumbled upon what looks like a bug in SQLite. I
accidentally created a column in a table that included a space in its
name,eg "Col 1". The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an error, no matter whether I
specify the
6 matches
Mail list logo
