Re: [sqlite] double_quote(text_field)

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

Re: [sqlite] Problem adding SQLite.Interop.060.DLL to windows mobile project

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,

Re: [sqlite] Inserting BLOB values

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 > &

Re: [sqlite] Inserting BLOB values

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