Thanks all!
I'll give those a go.
-Richard.
to specify "AS col2" since otherwise
it will not know what to name that column (if you're using names to access
them).
-Original Message-
From: Richard Boyd [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 6:02 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] quo
Richard Boyd wrote:
Use the built-in quote() function.
--
Ok I think I found it. (http://www.sqlite.org/lang_expr.html)
I'm not really familiar with this method of calling a function in an
expression. Is there away to have it only quote the TEXT columns and not the
INTEGER columns,
"Richard Boyd" <[EMAIL PROTECTED]> wrote:
> >>Use the built-in quote() function.
> --
>
> Ok I think I found it. (http://www.sqlite.org/lang_expr.html)
> I'm not really familiar with this method of calling a function in an
> expression. Is there away to have it only quote the TEXT columns and not
>>Use the built-in quote() function.
--
Ok I think I found it. (http://www.sqlite.org/lang_expr.html)
I'm not really familiar with this method of calling a function in an
expression. Is there away to have it only quote the TEXT columns and not the
INTEGER columns, or does it do this anyway by
>>Use the built-in quote() function.
--
Just what I'm after (huge sigh of relief) Is it sqlite3_quote?
I had a search through the documentation and didn't come up with anything.
Obviously I didn't look hard enough. I'll go back and look again.
Thanks very much for the quick response and
"Richard Boyd" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there anyway to get Sqlite to add 'quotes' around text strings when it is
> returning data from a select command?
>
Use the built-in quote() function.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hi,
Is there anyway to get Sqlite to add 'quotes' around text strings when it is
returning data from a select command?
For example:
I have a table called table0 which is created using
CREATE TABLE table0 (col1 INTEGER, col2 TEXT, col3 INTEGER);
I have a row in the table
1|this is a text
8 matches
Mail list logo