Re: [sqlite] double_quote(text_field)

2012-02-23 Thread Benoit Mortgat 
The same, escaping double quotes inside the double quotes:

SELECT '"' || replace(replace(text_field,'\','\\'),'"','\"') || '"'

On Thu, Feb 23, 2012 at 15:16, Bill McCormick  wrote:
> Yes, that should work.
>
> Thanks!!
> Dave Watkinson wrote, On 2/22/2012 5:33 PM:
>>
>> Did you mean something like
>>
>> SELECT '"'||text_field||'"' FROM table;
>>
>> so that your column's data is quoted?

-- 
Benoit Mortgat
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

2012-02-23 Thread Bill McCormick 

Yes, that should work.

Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:

Did you mean something like

SELECT '"'||text_field||'"' FROM table;

so that your column's data is quoted?


~~~
Dave Watkinson



On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik  wrote:


On 2/22/2012 6:03 PM, Bill McCormick wrote:


What is the easiest way to return a text field with double (") quotes?

SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;


I'm not sure I understand the nature of the problem. What's wrong with
simply

SELECT text_field FROM myTtable;

? There's nothing special about text fields that happen to contain a
double quote character.
--
Igor Tandetnik


__**_
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Dave Watkinson 
Did you mean something like

SELECT '"'||text_field||'"' FROM table;

so that your column's data is quoted?


~~~
Dave Watkinson



On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik  wrote:

> On 2/22/2012 6:03 PM, Bill McCormick wrote:
>
>> What is the easiest way to return a text field with double (") quotes?
>>
>> SELECT quote(text_field) FROM table; is close, but I'd rather have a
>> SELECT double_quote(text_field) FROM table;
>>
>
> I'm not sure I understand the nature of the problem. What's wrong with
> simply
>
> SELECT text_field FROM myTtable;
>
> ? There's nothing special about text fields that happen to contain a
> double quote character.
> --
> Igor Tandetnik
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Igor Tandetnik 

On 2/22/2012 6:03 PM, Bill McCormick wrote:

What is the easiest way to return a text field with double (") quotes?

SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;


I'm not sure I understand the nature of the problem. What's wrong with 
simply


SELECT text_field FROM myTtable;

? There's nothing special about text fields that happen to contain a 
double quote character.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Simon Slavin 

On 22 Feb 2012, at 11:03pm, Bill McCormick  wrote:

> What is the easiest way to return a text field with double (") quotes?
> 
> SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT 
> double_quote(text_field) FROM table;

Does

SELECT quote(quote(text_field)) FROM table;

work ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users