sorry, your corrections are correct
Thanks
Brona
>
> 1. I think you meant 'John Smith'; that's correct.
>
> 2. Correct. Result is John "the Big" Smith
>
> 3. I'm sure you meant 'John ''the Big'' Smith'.
>Result is John 'the Big' Smith
>
>
> Regards
Hi,
That's not, what Richard wrote me ::( but when I insert text into table, is
this all OK?
name='John Smith"
name='John "the Big" Smith' //double quotes around `the big`
name='John ''the Big'' Smith" //two singe quotes around `the big`
so it's exactly the oposite way Richard wrote me
You can solve all your problems by using strictly standard
quoting. The single quote (') is the quote character for
strings. The double quote (") is the quote character for
identifiers, which include column names. You don't need
to quote an identifier unless it has white space in it, so
you
>
> Bronislav Klučka wrote:
> > So there is nothing like C escape strings? (\", \',\\,etc.)
> > And the way to do it is to leave the field name, column name or
> string the
> > way it is, close it into double quotes and duplicate all double
> quotes in
> > the identificator?
> >
>
> Correct. That
Bronislav Klučka wrote:
So there is nothing like C escape strings? (\", \',\\,etc.)
And the way to do it is to leave the field name, column name or string the
way it is, close it into double quotes and duplicate all double quotes in
the identificator?
Correct. That is what the SQL standard
] Field name
but the results column name seems to be [brona'-kluc"ka] instead of
brona'-kluc"ka
> -Original Message-
> From: Greg Obleshchuk [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 27, 2003 10:32 AM
> To: 'Bronislav Kluèka'
> Subject: RE: [sqlite]
but the results column name seems to be [brona'-kluc"ka] instead of
brona'-kluc"ka
> -Original Message-
> From: Greg Obleshchuk [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 27, 2003 10:32 AM
> To: 'Bronislav Kluèka'
> Subject: RE: [sqlite] Field n
7 matches
Mail list logo