I have a Perl cron job that reads emails off a pop server once a
minute and stores them in a MySQL database on a remote machine. I
logged onto the MySQL server today and performed a select * from
messages where received 2003032200; Zero records were
returned.
I did some more
One way to handle this is to validate what you just inserted into the
database. Once you are sure of the success of your insert then delete it
from the pop server. I don't know how light weight you trying to keep
your program. This would certainly add some overhead not only to your
database
I have a Perl cron job that reads emails off a pop server once a minute
and stores them in a MySQL database on a remote machine. I logged onto
the MySQL server today and performed a select * from messages where
received 2003032200; Zero records were returned.
I did some more
I am trying to read email off a mail server using perl, parse it, and
then store the fields in a MySQL database. I managed to write the
first two parts in a couple of days, but now I've spent two weeks
trying to get the fields into a the Messages database. I have got
several fields to go in
I am trying to read email off a mail server using perl, parse it,
and then store the fields in a MySQL database. I managed to write
the first two parts in a couple of days, but now I've spent two
weeks trying to get the fields into a the Messages database. I
have got several fields to go in
, 2003, at 11:15 AM, PARLEY,THUNDER
(HP-MountainView,ex1) wrote:
You are using placeholders, right? ;-)
--Thunder
-Original Message-
From: gregg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:11 AM
To: [EMAIL PROTECTED]
Subject: MySQL DBI problem
I am trying to read email
: MySQL DBI problem
I am trying to read email off a mail server using perl, parse it, and
then store the fields in a MySQL database. I managed to write the
first two parts in a couple of days, but now I've spent two weeks
trying to get the fields into a the Messages database. I have got
On Wed, 26 Feb 2003, Paul DuBois wrote:
I have a few books on Perl that have DBI examples but they are not
made for MySQL and the examples are very Mickey Mouse compared to
what I'm trying to do. Any suggestions or directions to potential
resources will be greatly appreciated.
The webdb