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 (

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 "'"

[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