Thanks, that did it. The -y option doesn't seem to be in the man page though.
Kovid. On Sunday 11 June 2006 03:47, Jorge Bastos wrote: > Hum, the sql seams ok, > You must use: > --- > dbmail-util -pd -y > --- > > If you don't specify the "y" option he won't do anything, this is like a > confirm. (anyone correct me if i'm wrong) > > Jorge > > > > ----- Original Message ----- > From: "Kovid Goyal" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Sunday, June 11, 2006 7:20 AM > Subject: [Dbmail] deleting mails via sql > > > Hi, > > > > Is this the correct MySQL query to delete a message: > > UPDATE dbmail_messages SET deleted_flag=1, status=2 WHERE > > message_idnr=1234; > > > > The reason I ask is that running dbmail-util -pd repeatedly doesn't seen > > to > > remove the message from dbmail_messageblks (dbmail-2.1.6) > > > > Thanks, > > > > Kovid. > > -- > > _____________________________________ > > > > Kovid Goyal MC 452-48 > > California Institute of Technology > > 1200 E California Blvd > > Pasadena, CA 91125 > > > > home : +01 626 390 8699 > > office: +01 626 395 6595 (449 Lauritsen) > > email : [EMAIL PROTECTED] > > web : http://www.kovidgoyal.net > > _____________________________________ > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > !DSPAM:2,448bf813175731645754431! -- _____________________________________ Kovid Goyal MC 452-48 California Institute of Technology 1200 E California Blvd Pasadena, CA 91125 home : +01 626 390 8699 office: +01 626 395 6595 (449 Lauritsen) email : [EMAIL PROTECTED] web : http://www.kovidgoyal.net _____________________________________
