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
> 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
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
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
--- 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
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
--- 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?
>
7 matches
Mail list logo