I’m looking to do a database insert where:
One of the fields comes from a server-side variable
- set_session: set $_SESSION.test_var to some value
- db insert into CARS table: the MODEL field is bound to $_SESSION.test_var
Another fields’ value comes from the button on the frontend. Depending on which submit button I click, I want a different value to be inserted for a given field (YEAR) and for each record to be inserted.
- button 1 - dynamic event > flow: 1)set value of YEAR to 2000, 2)submit form
- button 2 - dynamic event > flow: 1)set value of YEAR to 2010, 2)submit form
Both fields are correctly filled out when doing a single insert, but they’re blank on multi-insert. I believe the multi-insert is working properly as it submits properly when I set static or dynamic values from the properties panel. Is there something I should do differently? Thanks!