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 (profileID char(32) etc...)" % (tableID) # > Where

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?