Forums

Multipage form with SaveDB on each page creates several rows

jrchukalescu 22 Dec, 2014
Hi,

I have a form with a dozen page. Each page has a submit button with an event attached to it.
In that event, I have a DB Save action to a table (same table for each page). On each page I have a cf_id hidden field and in the events, I have the multipage, db save and show html actions.

When I try the form in the front-end of my site, I can see that each time that I press a submit button (next page), the data is saved correctly in a row, but another row, with empty values is created in the same time...

I cannot understand what is wrong.

Does anybody have any idea on what's going wrong?

Thanks
GreyHead 22 Dec, 2014
Hi jrchukalescu,

If you add a Debugger action to one (or more) of the later pages that should show you the query that is being created.

If I understand correctly one record is being updated correctly and another blank record created as well. I'm not sure how this can happen with only one DB Save action in the page.

Bob
jrchukalescu 22 Dec, 2014
Hi Bob,

Thanks for your answer.

I did some more testing now that I'm back home and the problem does not occur here... I did my earlier tests from a connection at work, which lead to the problems described before...

I will try to do some more testing tomorrow from work... Maybe the issue is browser-related (double submission?) or occurs because we are behind a proxy... This is weird, as you said, that duplicates appear with only one DB Save.

By the way, I do not see the query in the debugger, I just see the session data and the form data...
This topic is locked and no more replies can be posted.