Re: [sqlite] double_quote(text_field)

[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 <itandet...@mvps.org> 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<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] Problem adding SQLite.Interop.060.DLL to windows mobile project

[Dave Watkinson]

http://www.google.com/

gave me

http://sqlite.phxsoftware.com/forums/p/1569/8573.aspx
 
which contains

"This issue has been covered several times on the forum. The upshot is that
Visual Studio will not deploy the Interop DLL automatically, so you will
have to copy it to your device or emulator manually during development. Copy
it to the same device folder to which System.Data.SQLite.dll is deployed."


HTH




On Fri, Jan 21, 2011 at 5:38 PM, Simon Slavin  wrote:

>
> On 21 Jan 2011, at 9:49pm, naresh pasnur wrote:
>
> > I'm developing a  windows mobile application using Visual Studio 2008.
> > I'm able to add  "System.Data.SQLite.dll" to my project's reference.
> > However, when I'm trying to add  "SQLite.Interop.060.DLL" to my project's
> > reference, it's throwing this error
> > *"A reference to SQLite.Interop.060.DLL cannot be added"
> > *
>
> While you are free to post details of your problem here, it doesn't really
> have anything to do with SQLite.  The SQLite team did not supply that DLL,
> it was made up by someone else.  Someone with good understanding of VS2008
> and DLLs is much better placed to solve your problem.  So you will probably
> do better posting your problem in a VS2008 forum than here.
>
> Simon.
> ___
> 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] Inserting BLOB values

[Dave Watkinson]

oopsy - thx jay

phooey... i just *knew i should have stayed in bed this morning :-|




On Mon, Dec 20, 2010 at 12:47 PM, Jay A. Kreibich <j...@kreibi.ch> wrote:

> On Mon, Dec 20, 2010 at 12:38:23PM -0500, Dave Watkinson scratched on the
> wall:
> > hey there
> >
> > you seem to have an unescaped apostrophe inside your string, and the
> string
> > itself isn't enclosed by matching quotes
> >
> > X'7801B58E41'
>
>   This is the standard format for a literal BLOB.  See the "Literal
>  Values" section of  http://sqlite.org/lang_expr.html#litvalue
>
>   -j
>
> --
> Jay A. Kreibich < J A Y  @  K R E I B I.C H >
>
> "Intelligence is like underwear: it is important that you have it,
>  but showing it to the wrong people has the tendency to make them
>  feel uncomfortable." -- Angela Johnson
> ___
> 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] Inserting BLOB values

[Dave Watkinson]

hey there

you seem to have an unescaped apostrophe inside your string, and the string
itself isn't enclosed by matching quotes

X'7801B58E41'




~~~



On Mon, Dec 20, 2010 at 12:27 PM, Dagdamor  wrote:

> Oh, and I forgot to add - the reply comes from PHP, from the functions
> called sqlite_last_error() and sqlite_error_string().
>
> --
> Regards,
> Serge Igitov
> ___
> 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