On Wednesday 24 of August 2005 16:27, Tony Finch wrote:
> but if you
> want the ${extract to work on the result of the QUOTA_STANDARD query
> you'll have to do the QUOTA_STANDARD lookup separately. At the moment
> you're interleaving SQL and Exim expansions in a very dodgy manner. Try
> something like
Thanks, $value is nice. Did the trick.
[...]
> Though to be honest you should probably re-arrange your tables so that the
> whole quota calculation can be done with one SQL query.
That's impossible (not easillly) unfortunately. mysql 4.1 would help a lot -
when using subqueries the task would be easy.
> Tony.
Thanks again,
--
Arkadiusz Miśkiewicz PLD/Linux Team
http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/