Multiple Update on page load

Hi Ray, I applied the multiple update behavior in a page with on load trigger, but is not working. I had to change the trigger to page submit and ad onLoad="document.form1.submit()" to the body tag. I'm attaching the page.
Thank you for your help.

You don't need to use a multiple update server behavior. Use a regular MySQLi Update server behavior. You only need multiple update if you are updating based on a form submit where each value might be changed individually.

You would just have to manually add a second ->addFilter() call to the code to filter on more than one column when doing the update.

Hi Ray, I'm using the multiple update because I want to update the values of a table column with the auto increment id column.

This is what I did:
I made a page that has a multiple file upload behavior. This page, after the update, you are supposed to arrange the pictures by dragging them so it has also a drag and drop behavior. This drag and drop behavior needs an order column in the database with unique values, but when I upload multiple pictures the order column is inserted with the same values, so I placed the multiple update behavior in another page so as soon as I upload the pictures, the order column is updated copying the auto increment column values.

I think you can do that with a simple update statement using the "MySQLi Execute Query" server behavior like:

UPDATE fotos SET fotosORD = fotosID WHERE fotos.fotosSUBCATID = col_cat AND fotos.fotosORD = col_orden

and use parameters for col_cat and col_orden mimicking the recordset you have currently.