AW: [Exim] concatenation of two strings?

this does not work. :-(

my config is:

pnm_verify:
driver = accept
condition = "${if eq {${lookup mysql {select status from MX_email
where email=${quote_mysql:\@${domain}} or
email=${quote_mysql:${local_part}\@${domain}} order by email desc limit
1}}}{active} {1}{0}}"
verify_only = true
verify_recipient = true
verify_sender = false


and I get the following error:

Jul 3 09:00:04 s_sys@mx1 exim[18552]: 2002-07-03 09:00:04
H=localhost.localdomain (biehl) [127.0.0.1] F=<a.biehl@???>
temporarily rejected RCPT <a.biehl@???>: MYSQL: query failed: You
have an error in your SQL syntax near '@pulsaar.de order by email desc
limit 1' at line 1


can you help me?

thank you,
Alex

> -----Ursprüngliche Nachricht-----
> Von: Philip Hazel [mailto:ph10@cus.cam.ac.uk]
> Gesendet: Dienstag, 2. Juli 2002 21:39
> An: Tamas TEVESZ
> Cc: yammy; exim-users@???
> Betreff: Re: [Exim] concatenation of two strings?
>
>
> On Tue, 2 Jul 2002, Tamas TEVESZ wrote:
>
> > On Tue, 2 Jul 2002, yammy wrote:
> >
> > > is it possible to concat two strings?
> > > i need this in order to quote (mysql_quote) them.
> > > in detail i need ${local_part}@${domain} quoted for mysql.
> >
> > ${quote_mysql:$local_part}@${quote_mysql:$domain}
> >
> > not exactly a concatenation, but the net result is pretty much the
> > same.
>
> Er, why not just use the obvious?
>
> ${quote_mysql:$local_part@$domain}
>
> Am I missing something here? [If you like lots of curlies, you can use
>
> ${quote_mysql:${local_part}@${domain}}
>
> if you really want to.]
>

> --
> Philip Hazel            University of Cambridge Computing Service,
> ph10@???      Cambridge, England. Phone: +44 1223 334714.

>
>