Re: [exim] mysql lookup on update: $value is affected rows?

It's NOT updating at that point. That's why there's a 0. I still
don't know what is happening but I'm sure it's my fault. So don't
anyone waste any more thought on this.

In case you're curious, here's proof:

I added 2 new debugging routers. So now I have:

---

pre_affected_rows:
   driver = redirect
   debug_print = PRE: ${lookup mysql{\
           select last_use from in_out where in_id = RECIPIENT_ID \
                                        and out_id = REPLY_ID}{$value}{xxx}}
   data =

affected_rows:
   driver = redirect
   debug_print = ${lookup mysql{\
update in_out set last_use = now() where in_id = RECIPIENT_ID \
                                    and out_id = REPLY_ID}{$value}{xxx}}
   data =

post_affected_rows:
   driver = redirect
   debug_print = POST: ${lookup mysql{\
                   select last_use from in_out where in_id = RECIPIENT_ID \
                                    and out_id = REPLY_ID}{$value}{xxx}}
   data =

----

From the debug:

    result: PRE: 2004-10-26 16:33:21
    result: POST: 2004-10-26 16:33:21

I'm very sure that there's something wrong with my databases. But I
have to quit now.

Thank you for your help.

Marilyn