Author: Paul Robinson Date: To: Rob Butler CC: exim-users Subject: Re: [Exim] SQL Lookup modification request
Rob Butler wrote:
>I was wondering the other day if it would be possible to use exim's SQL
>based lookups to perform inserts into a database.
> I've used exim with SQL for the last 5 years. I can't think of a
situation where I would want to do an INSERT from exim itself, save
perhaps for logging. What's your plan with this? Nearly everything I can
think of is handled by other applications.
>had a problem. Modify the code that retrieves the result data to check if
>there was a result set returned. If one was returned, and there is a
>problem processing it, fail.. If no result set was returned, then don't try
>to process one, and don't fail.
> But then, when I am expecting a result set and one doesn't come back, it
hasn't "failed" and exim is most likely to get confused when processing
SELECTs.
It depends on what you mean by a "failure" really. In the context of
exim, a SELECT coming back empty is not an error in processing, but
really, it is a failure in this context.