uly 05, 2006 5:13 PM
Subject: Re: [sqlite] Syntax Errors with various strings?
Gussimulator wrote:
Thanks Christian, I'll give it a shot later.
Just because using quotation marks (did a quick macro that adds them to
my string) did the job, doesnt mean its a better solution than this one
Gussimulator wrote:
Thanks Christian, I'll give it a shot later.
Just because using quotation marks (did a quick macro that adds them
to my string) did the job, doesnt mean its a better solution than this
one.
In particular, if your strings include the ' character, you will need
to double
To:
Sent: Wednesday, July 05, 2006 7:18 AM
Subject: Re: [sqlite] Syntax Errors with various strings?
Have you tried using the quote() function?
From http://www.sqlite.org/lang_expr.html
quote(X) This routine returns a string which is the value of its
argument suitable for inclusion into another S
Enclosing the strings with quotation marks did the job.
Thanks a lot.
- Original Message -
From: "C.Peachment" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 05, 2006 6:39 AM
Subject: Re: [sqlite] Syntax Errors with various strings? & ...Ampersand
The soluti
Gussimulator wrote:
Hi, When I have strings with "-", "!", "\" or similar characters I get a
syntax error.. Now, I thought this would happen with a few of this chars so I made 2 routines in my program,
one that converts each of this chars into a flag string, which then, by the other routine ca
Have you tried using the quote() function?
>From http://www.sqlite.org/lang_expr.html
quote(X)This routine returns a string which is the value of its
argument suitable for inclusion into another SQL statement. Strings are
surrounded by single-quotes with escapes on interior quotes as need
The solution I have adopted to both of these issues is to:
1. ensure all strings are enclosed by matching quotation marks, and
2. use the question mark substitution form of prepared statement
with subsequent bind of parameters. This can only be done from a
programming language and not the command
Hi, When I have strings with "-", "!", "\" or similar characters I get a
syntax error.. Now, I thought this would happen with a few of this chars so I
made 2 routines in my program, one that converts each of this chars into a flag
string, which then, by the other routine can be reverted to the
8 matches
Mail list logo
