From: Kaspar Schiess <eule@...>
Date: 2004-05-14T05:57:08+09:00
Subject: Re: nasty regexp problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Francis,

I have nothing to contribute to your problem, except that it looks
rather nasty. I would suggest at least two better ways of handling your
original problem in lafcadio (if I may):

a) if dbh is your DBI::DatabaseHandle, use dbh.quote to quote strings in
a db independent fashion. This however has failed on me on several
occasions, that is why I propose

b) Use ? and replace by bindings (much as I proposed in my patch to
lafcadio for BLOB's). That always works nicely, except in special places
in the sql statement.

String quoting is very database dependent.

Sorry for not answering any of your questions directly, you probably did
not want a roundabout answer.. :(

best regards,


- --
kaspar

semantics & semiotics
code manufacture

www.tua.ch/ruby
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAo+HdFifl4CA0ImQRAtgXAKCunvBmHlauIm5M1Ap2j6zScfWBUACgpba/
bewum0SCv+tw6JGZbPA9QFU=
=GOqS
-----END PGP SIGNATURE-----