Re: [Dbmail] Restore status

2006-11-28 Thread Jorge Bastos
Thanks Paul - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Tuesday, November 28, 2006 1:14 PM Subject: Re: [Dbmail] Restore status update dbmail_messages set status=2 where status>2 and mailbox_idnr

Re: [Dbmail] Restore status

2006-11-28 Thread Paul J Stevens
update dbmail_messages set status=2 where status>2 and mailbox_idnr in (select mailbox_idnr from dbmail_mailboxes b join dbmail_users u on b.owner_idnr=u.user_idnr where u.userid='testuser1'); Jorge Bastos wrote: > Guys, sorry, > I know this has been asked several times bu

[Dbmail] Restore status

2006-11-28 Thread Jorge Bastos
Guys, sorry, I know this has been asked several times but tell me. I have deleted and purged messages in imap, and i want to restore those purged messages to deleted only, and a certein user only. Who can give me a hand on this? Jorge