Hello everyone, I'm tuning up my $sql_select_policy in order to improve functionality of amavis on my mail server and I'm struggling with something which I'd imagine would be simple. I need to extend this query as follows:
" ... OR alias.goto LIKE ('%RECIPIENT%')" where RECIPIENT is the individual recipient address for the message in question and the % signs are wrapping it in order to treat it as a needle in a haystack. I need the same recipient address which appears in the first set of single quotes when the %k macro is expanded in the typical policy lookup query (per the various README examples)... Can anyone help me? Thanks, Daniel ------------------------------------------------------------------------- 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/