Problem with DB update

chriso0258 24 Aug, 2012
When I click the surplus link and bring up a list of equipment, I select one item on the list and the surplus form comes up. The user completes the form, which has a couple of drop down boxes, and then submits it. The surplus form has a hidden field which will replace the data in the Region field (which is not shown on the form) with the word "Surplused".

When submitted, the data from the drop down boxes gets updated, but the Region field is not being updated. I have verified that the hidden field name and id is labeled the same as in the "Add Equipment" form.

I added the debugger to the on Submit section, but even the debugger does not show up. If I test the form from CF, the debugger works and shows that the hidden field is sending the data.

I'm baffled on this one.

Thanks.
GreyHead 25 Aug, 2012
Hi chriso0258 ,

Sounds like one for Max, you've tested pretty much everything I would suggest. One more step might be to turn Site Debug on temporarily and check if that shows you the MySQL query - there may be a clue there.

Bob

Bob
Max_admin 26 Aug, 2012
Hi,

If you have a model id, then did you add it to the hidden field name ?

You can add a debugger then a show stopper in the on submit event to see how the data sent to the save process looks like.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.