Hi there,
I'm thinking of doing the penpal thing, but, just to check, is this right?:
(line 910 in V2.5.1 of amavisd)
'sel_penpals_msgid' => # with a nonempty message-id references list
"SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid".
" FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id".
" WHERE sid=? AND content!='V' AND ds='P' AND message_id IN (%m)".
" AND rid!=sid".
" ORDER BY rid=? DESC, msgs.time_num DESC LIMIT 1",
That last line, "ORDER BY rid=?".. a condition inside the order clause?
hmm. Looks wrong to me, but the evidence to the contrary is that nobody has
reported sql errors yet!
my regards,
Riaan
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
