how to update database with the database adapter?
Summaryneed to update rows based on a value found in one of the fields
I'm processing data from a database using the DB adapter. I'm able to get data from the database.
after processing that data, i want to use the primary key from that row of data to update a field value.
the workflow is:
Get data from DB
for each row
update a field in db to know its been processed.
I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.