RE: [sqlite] unrecognized token error

2006-11-15 Thread Robert Simpson
> -Original Message- > From: Florent THIERY [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 15, 2006 9:27 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] unrecognized token error > > Hi > > My request: > > "create table %s (

[sqlite] unrecognized token error

2006-11-15 Thread Florent THIERY
Hi My request: "create table %s (profileID char(32) etc...)" % (tableID) # Where tableID is a 32 char hexstring (hash) 4b0c25789ab124628444951dd995fdcc in this case create table 4b0c25789ab124628444951dd995fdcc (profileID char(32) , _soi char(7) etc. ) The unswear: _sqlite.DatabaseError:

Re: [sqlite] Unrecognized token error

2006-03-20 Thread Jay Sprenkle
On 3/19/06, Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hi John, > > On 19/03/2006, at 18:23, John Stanton wrote: > > > Tito Ciuro wrote: > >> Hello, > >> I'm trying to store a string and I get the following error: > >> unrecognized token: \"!\"\" > >> This happens with SQLite 3.2.7 > >> Any ideas? > >

Re: [sqlite] Unrecognized token error

2006-03-19 Thread Nemanja Corlija
On 3/20/06, Tito Ciuro <[EMAIL PROTECTED]> wrote: > If I escape single quotes (that is, from "'" to "''"), then > everything is fine. I usually do that when I want to query for a > value that contains a quote (i.e. O'Rourke). > > However, why do I have to manipulate the string value to be stored? >

Re: [sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? If I escape single quotes (that is, from "'" t

[sqlite] [LONG]Re: [sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? Here's the string (it's a preferences file):

Re: [sqlite] Unrecognized token error

2006-03-19 Thread John Stanton
Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string?

[sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito