Tom Allison wrote: > How do you get all the physical message blocks in order? > (of course, for bogofilter, this doesn't really matter.) > > > > select phymsg.id, messageblk > from > dbmail_users u, > dbmail_mailboxes mb, > dbmail_messages msg, > dbmail_physmessage phymsg, > dbmail_messageblks blks > where > u.user_idnr = mb.owner_idnr > and u.userid = '__public__' > and mb.name = 'SPAM' > and mb.mailbox_idnr = msg.mailbox_idnr > and msg.deleted_flag = 0 > and msg.physmessage_id = phymsg.id > and phymsg.id = blks.physmessage_id > order by phymsg.id > ;
If you only want to read the Public/Spam box, why do you want to read the box through SQL? Use fetchmail I'd say. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
