Author: Nico Erfurth Date: To: Alexander Sabourenkov CC: exim-users Subject: Re: [Exim] mysql lookups / !SELECT / affected_rows
Alexander Sabourenkov wrote: > Hello.
>
> Nico Erfurth wrote:
>
>>
>>
>> What's !SELECT for?
>
>
> Not SELECT [-like].
>
> I.e. UPDATE, DELETE, INSERT, GRANT/REVOKE (not that this is likely to be
> used in lookups :-) ).
> They do not return result sets.
>
> Problem was, I needed to insert rows into a table to implement some
> hairy rate-limiting scheme.
> And although query was succeeding, and rows were inserted, the lookup
> returned 'defer'.
Ahhh, well ... :)
${lookup}'s are for lookups ... :)
If you want to do rate-limiting, run a daemon, and use ${readsocket}
(exim4.11).
