Re: [sqlite] quoting strings issue

2005-06-09 Thread Puneet Kishor
On Jun 9, 2005, at 2:30 PM, D. Richard Hipp wrote: On Thu, 2005-06-09 at 14:29 -0500, Puneet Kishor wrote: Thanks to those who responded. However, this thread is going away from what I really asked... not how to quote a string, but to confirm whether or not SQLite had any idiosyncrasies relate

Re: [sqlite] quoting strings issue

2005-06-09 Thread Jay Sprenkle
> Thanks to those who responded. However, this thread is going away from > what I really asked... not how to quote a string, but to confirm > whether or not SQLite had any idiosyncrasies related to string-quoting > other than the normal "escape single-quotes within the string." You're doing it the

Re: [sqlite] quoting strings issue

2005-06-09 Thread D. Richard Hipp
On Thu, 2005-06-09 at 14:29 -0500, Puneet Kishor wrote: > Thanks to those who responded. However, this thread is going away from > what I really asked... not how to quote a string, but to confirm > whether or not SQLite had any idiosyncrasies related to string-quoting > other than the normal "es

Re: [sqlite] quoting strings issue

2005-06-09 Thread Puneet Kishor
Thanks to those who responded. However, this thread is going away from what I really asked... not how to quote a string, but to confirm whether or not SQLite had any idiosyncrasies related to string-quoting other than the normal "escape single-quotes within the string." Btw, I am using $dbh->q

Re: [sqlite] quoting strings issue

2005-06-09 Thread Clark Christensen
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Clark Christensen wrote: > > >IOW, something like. > > > >$sql = "update t1 set a = ?"; > >$string = $dbh->quote( qq(some long string; has many > >'single quotes') ); > >$sth = $dbh->prepare($sql); > >$rc = $sth->execute($string); > > > >will probabl

Re: [sqlite] quoting strings issue

2005-06-09 Thread Dennis Cote
Clark Christensen wrote: IOW, something like. $sql = "update t1 set a = ?"; $string = $dbh->quote( qq(some long string; has many 'single quotes') ); $sth = $dbh->prepare($sql); $rc = $sth->execute($string); will probably eliminate both the prepare() error, and an UPDATE error later. -Clark

Re: [sqlite] quoting strings issue

2005-06-09 Thread Clark Christensen
--- Puneet Kishor <[EMAIL PROTECTED]> wrote: > While I await some insight into my previously posted > "database locking" > problem, I have a question regarding quoting text. > > Does SQLite have any issues with anything other than > single-quotes? For > example, with colon, or semi-colon? >