Re: [sqlite] apostrophes in strings...

On Wed, Feb 23, 2011 at 12:50 PM, BareFeetWare wrote: > On 21/02/2011, at 8:11 AM, Scott Hess wrote: >> You can also convert: >>  ATTACH DATABASE x AS y KEY z >> to: >>  SELECT sqlite_attach(x, y, z) >> where the parameters can be turned into bind arguments.  Then

Re: [sqlite] apostrophes in strings...

On 21/02/2011, at 8:11 AM, Scott Hess wrote: > You can also convert: > ATTACH DATABASE x AS y KEY z > to: > SELECT sqlite_attach(x, y, z) > where the parameters can be turned into bind arguments. Then embedded quotes > won't be an issue. SQLite won't allow an "attach" statement within a

Re: [sqlite] apostrophes in strings...

On 23 Feb 2011, at 3:15pm, Sam Carleton wrote: > Thank you, that is what I needed. Now to statisfy my curiosity... What > exactly is the KEY value? It took me a second read of this message to grin at it. Simon. ___ sqlite-users mailing list

Re: [sqlite] apostrophes in strings...

On Wed, Feb 23, 2011 at 10:15 AM, Sam Carleton wrote: > Kevin, > > Thank you, that is what I needed. Now to statisfy my curiosity... What > exactly is the KEY value? > The KEY is used by the (proprietary) SQLite Encryption Extension. It allows you to ATTACH an

Re: [sqlite] apostrophes in strings...

I believe the key is used for attaching to encrypted databases. -scott On Wed, Feb 23, 2011 at 7:15 AM, Sam Carleton wrote: > Kevin, > > Thank you, that is what I needed.  Now to statisfy my curiosity...  What > exactly is the KEY value? > > On Tue, Feb 22, 2011 at

Re: [sqlite] apostrophes in strings...

Kevin, Thank you, that is what I needed. Now to statisfy my curiosity... What exactly is the KEY value? On Tue, Feb 22, 2011 at 10:39 PM, Kevin Benson wrote: > The suggestion apparently derives from comments in attach.c > For example: > >

Re: [sqlite] apostrophes in strings...

The suggestion apparently derives from comments in attach.c For example: http://gears.googlecode.com/svn/trunk/third_party/sqlite_google/src/attach.c /* ** An SQL user-function registered to do the work of an ATTACH statement. The ** three arguments to the function come directly from an attach

Re: [sqlite] apostrophes in strings...

On Mon, Feb 21, 2011 at 9:42 AM, Sam Carleton wrote: > On Sun, Feb 20, 2011 at 4:11 PM, Scott Hess wrote: > >> You can also convert: >> ATTACH DATABASE x AS y KEY z >> to: >> SELECT sqlite_attach(x, y, z) >> where the parameters can be turned into

Re: [sqlite] apostrophes in strings...

You can also convert: ATTACH DATABASE x AS y KEY z to: SELECT sqlite_attach(x, y, z) where the parameters can be turned into bind arguments. Then embedded quotes won't be an issue. -scott On Sun, Feb 20, 2011 at 11:31 AM, Pavel Ivanov wrote: > I believe doubling the

Re: [sqlite] apostrophes in strings...

I believe doubling the single quote inside the string literal should help. Pavel On Sun, Feb 20, 2011 at 2:23 PM, Sam Carleton wrote: > This is a bit crazy and I know the ideal way would be to not allow the > apostrophy in the first place but, my focus is easy of

[sqlite] apostrophes in strings...

This is a bit crazy and I know the ideal way would be to not allow the apostrophy in the first place but, my focus is easy of use for my customers, as compared to easy for me... I had a customer that saved their SQLite database here: D:/My Events/President's Day/event.sqlite My software uses

Re: [sqlite] Apostrophes in strings

Apply the php-function "sqlite_escape_string" on all the string data you insert/update to the database. That should to the trick. Thanks, it just makes a '' from ' instead of \' as with MySQL. Reminds me a bit of Visual Basic... It's the standard SQL way of escaping a ' character (MySQL (and

Re: [sqlite] Apostrophes in strings

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 07 August 2004 11:46, Yves Goergen wrote: > Hi everyone, Hi, > I found the SQLite DLL for PHP today and just wanted to do some > testing with it. I could rewrite my dump of the MySQL tables and data > so that SQLite would understand it.

[sqlite] Apostrophes in strings

Hi everyone, I found the SQLite DLL for PHP today and just wanted to do some testing with it. I could rewrite my dump of the MySQL tables and data so that SQLite would understand it. But there's a fundamental problem left. I have strings that contain ' characters. But strings are written in ''