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
