Ilja schrieb: > On Mon, 11 Oct 2004 23:19:37 +0200, Gerrit P. Haase <[EMAIL PROTECTED]> wrote: >> Hi, >> >> i.e. I'm looking for a script that deletes any duplicated >> messages on a per folder basis. Unfortunately is this not >> supported by Mozilla Mail. >> >> I'm not sure yet if it is a problem with dbmail or with dspam >> or mozilla which I'm testing to filter the mail, but I get lot >> of duplicates. Since I'm still testing it is not important, >> but may indicate a bug in my installation or any of the tools >> besides my MTA (which is bugfree;)
> Problem is... what is a duplicated message? SELECT messages where messageID and folderID are identical, but this statement is not supported by SQL:-( > If the messages have the same Message-Id header, you could do a search > for that. Yes, I thought that e.g. things like this are common tasks and that there may be a collection of useful SQL snippets somewhere to do Postmaster tasks like this. Gerrit -- =^..^=
