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

On Mon, Jul 07, 2008 at 05:01:16PM -0500, Lee Doran wrote:

>The problem I have is this, we had a programmer write (wrong) a perl
>script that loads emails into a MySql database for archiviing purpose
>when they processed.  The problem is sometimes we get Sql syntax errors
>when the script is processing some domain names and sometimes when there
>are attachments.  The attachments information is kept in separate tables
>and the attachments themselves are saved out to a location on the disk.

Make sure you use DBI->quote() on the raw data.  Otherwise you get all
kinds of errors when there are quotes in the data stream.

>NOTE:  I said sometimes - sometimes it well just works fine. 

When there are no special characters...

- -- 
Regards...              Todd
Well, it's Karch...   --frequently heard after every amazing move he does
Linux kernel 2.6.24-18-generic  13 users,  load average: 0.01, 0.08, 0.10
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIc51yY2VBGxIDMLwRApB0AJoDUYt+wCGSjIuiXOUNpJS+PWJGkACeI/G1
EkwaZ3anIKYyhz+PNgFoguE=
=TLlH
-----END PGP SIGNATURE-----

-- 
## List details at http://lists.exim.org/mailman/listinfo/exim-users 
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

Reply via email to