Hi.
I'm trying to convert a sqlite3 database into sqlite2 database with:
c...@emx:~$ sqlite3 banco.sqlite3 .dump > dump3
c...@emx:~$ echo '.read dump3' | sqlite banco.sqlite2
CREATE TABLE `abc` (`test` TEXT);
SQL error: unrecognized token: "`"
c...@emx:~$
I know that the problem is in `abc`, but
> -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 (
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:
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?
> >
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?
>
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
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):
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?
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
On Thu, 2005-03-03 at 19:00 -0600, David Taylor-Fuller wrote:
>char* sqlStmt=sqlite3_mprintf("INSERT INTO %q
> (FileName,ArtistName,TrackNum,TrackName,AlbumName,Genre,Year) values
> (%q,%q,%q,%q,%q,%q,%q)",
> Can Someone please I beg of you explain to me why I am getting the
> following
Ok I have skimmed the archives and even though people have had similar
problems there solution all point to using '' as an escape instead of
'\. However that doesnt solve my problem. I am writting a mp3player
and wanted to use sqlite as the db backend for the library. Now all
was going well untill
11 matches
Mail list logo