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 ser
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 inv
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 investigat
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
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 a
r but it wasn't inserted either.
Thanks.
On Wednesday, February 26, 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:
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