Hi,
I am still working on a problem I posted about earlier and hope someone could help me out. This is my setup:
I would expect this to work, because I am looping through all matching records and with each loop, the previous record does not get selected anymore because of the changes I made. Until there are no more records left to select.
The problem is, that the DB Save action is not executed when I would expect. If I do nothing to the form->data array, only the first record is updated. When I clear form->data before the Event Loop, only the 2nd record gets updated. Which, I think, means that DB Save is executed after the loop completes.
How can I solve this? For particular reasons (different users get different emails) I cannot run one major UPDATE query and send bulk mail, but have to handle each record individually.
I am still working on a problem I posted about earlier and hope someone could help me out. This is my setup:
I would expect this to work, because I am looping through all matching records and with each loop, the previous record does not get selected anymore because of the changes I made. Until there are no more records left to select.
The problem is, that the DB Save action is not executed when I would expect. If I do nothing to the form->data array, only the first record is updated. When I clear form->data before the Event Loop, only the 2nd record gets updated. Which, I think, means that DB Save is executed after the loop completes.
How can I solve this? For particular reasons (different users get different emails) I cannot run one major UPDATE query and send bulk mail, but have to handle each record individually.