I notice that whenever I use more than 1 param it either doesn’t work or just copies values from the 1st param…
I was trying to get to the bottom of this so I set up a test page with a query and server connect form like this:
(all the fields are properly named and tested with a database update action)
now I set up a simple custom query using just one of the fields
this works as intended:
However, if I want to update another row and add another parameter like this:
I’m getting the same value used in both rows:
And, of course if I try to use the Id field and yet another param it won’t do anything as it’ll probably want to use :P1 for it…
Now I know that what I’m doing here can be done with Database Update action but I hoped to do something a bit more complicated than that… Also I want to add a line break - which doesn’t work in expression builder as far as I can tell…
Community Page
Last updated:
Last updated: