Save in multiple tables

Anthonie 19 Nov, 2012
Hi,

I have a form whitch updates the information into two tables by two DB Save actions, but every submit creates two records in each table. One record whith the correct data and one with nonsense data.
What am I doing wrong.

Regards,
Anthonie
GreyHead 19 Nov, 2012
Hi Anthonie,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob
Anthonie 20 Nov, 2012
Hi Bob,

Here are the results of the debugger, I hope You can help me with this information.

Data Array:
Array
(
[option] => com_chronoforms
[lang] => nl
[chronoform] => TEST_Multi_Form
[event] => submit
[cf_sid] => 6cf38b94b0677595d95f8b607643310c
[Itemid] =>
[hrefsite] => http://www/test.nl
[latitude] => 0192837465
[longitude] => 5647382910
[icontype] => _Hotel-Restaurant
[infographicstype] => 98
[attribute1] => NEE
[attribute2] => JA
[attribute3] => NEE
[attribute4] => JA
[attribute5] => NEE
[attribute6] => JA
[attribute7] => 1
[attribute8] => Ja
[attribute9] => NEE
[mapid] => 2
[zoombyclick] => 16
[baloon] => 3
[publish_up] => 2012-11-20 10:54:56
[hrefsitename] => Ga naar de website
[markercontent] => 1
[showcontact] => 1
[descriptionhtml] => 1
[title] => Testcity
[description] => Camperplaats test
[input_submit_8] => Submit
[e6cce1104856902f0cf67240260a74db] => 1
[language] => nl-NL
[name] => Camperplaats test
[address] => Teststraat 123
[postcode] => 987AQ
[suburb] => Testcity
[state] => Testprovincie
[country] => Nederland
[telephone] => 1234567890
[email_to] => [email]test@test.nl[/email]
[input_submit_2] => Volgende pagina
)
Validation Errors:
Array
(
)

GreyHead 20 Nov, 2012
Hi Anthonie,

I don't see any sign there of the Debug output from the DB Save actions??

Is the Debugger in the On Submit event after the DB Save actions?

Bob

PS This looks like a multi-page form, it may be that you are saving a record between the pages and then creating a new one after the second page?
Anthonie 26 Nov, 2012
Hi Bob,

Sorry for the late answer.
Correct it is a multi page form. I have deleted the multipage function and the form saves the data now correct.
I wil figure out how to create a multipage form.
Thanks for so far.

Regards,
Anthonie
This topic is locked and no more replies can be posted.