On 12/14/06, Paul J Stevens <[EMAIL PROTECTED]> wrote:
SQL is your friend. On sqlite and postgres you can do: update dbmail_mailboxes set name="MAIL-ARCHIVE/yyyy/mm" where mailbox_idnr = ( select mailbox_idnr from dbmail_mailboxes b join dbmail_users u on b.owner_idnr=u.user_idnr where u.userid='testuser1' and b.name='INBOX' );
Why would you do the extra step in there when you could do update dbmail_mailboxes set name="MAIL-ARCHIVE/yyyy/mm" where name='INBOX' and owner_idnr = (select user_idnr from dbmail_users where userid='testuser1');
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
