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
