[Exim] error messagge

hi,

i've a director like this:

mysql_user:
   driver = smartuser
   condition = ${lookup mysql{select domain from mail where
               domain='${domain}' and username='${local_part}' and
               is_alias='no'}{$value}fail}
   transport = mysql_delivery

it happens that some user make a mistake in the To: field
(like 'user@??? - notice the "'")

exim spools this mail and never write an errormessage back.

this is the log:

(1999-11-25 11:50:16 11qwSJ-0003vd-00 failed to expand condition"${lookup
mysql{select domain from mail where domain='${domain}' and
username='${local_part}' and is_alias='no'}{$value}fail}" for mysql_user
director: lookup of "select domain from mail where domain='my_doma.in' and
username=''my_username' and is_alias='no'" gave DEFER: MYSQL: query
failed: You have an error in your SQL syntax near 'my_username' a
nd is_alias='no'' at line 1)


do you know any sollutions?


robert

---
di. robert rotman                                   inode.graz
phone -> ++43-(0)316 811451          ++43-(0)316 811451 <- fax
rotman@???                      http://www.graz.inode.at/
--
this letter was written on recycled bytes used by deleted mail.