Forums

I made a connection in cfv5 with the name gebruikers.
In the front list tab I add edit_gebruiker:load in the form event of the edit item.
edit-gebruiker is a cfv5 form where the data shows up correctly after choosing a datarecord form the displayl list.
In this form I add a Connection Action in the On Submit field. (connection's name: gebruikers, action:save)
After submit I get the message: correctly saved, but the record is unchanged and a new empty record is created.

Hi tvdgreft,

Please see this FAQ

I'm guess that this bit may be missing: "Next we will add the form elements we need, including a 'Hidden field' element which will hold the value of the primary key from the table, usually id or cf_id, to make sure we update the same record."

Bob

Hi Max,

I noticed that. The first field in my form is a hidden field with Field Name and field ID gebruiker[id].
The primary key of the table is id. and the model in CCv5 connection is gebruiker.
Even then the record is not modified, but a new empty record is created.

Hi tvdgreft,

Please post a screenshot for your connected form "setup" and "designer" sections.

Regards,
Max

Desing screen:

[IMG]http://i57.tinypic.com/28p2ee.png[/IMG]

setup screen:

[IMG]http://i57.tinypic.com/2zp8fip.png[/IMG]

The 2nd image is clear, the first one is not, I wanted to check your fields names!

Regards,
Max

Hi Max,

The form is large i'll do it in 2 parts. Is this better?

Everything looks good, please add a "debugger" action instead of the "Connection action" and post the debug report after editing a record!

Oh, please remove the "handle arrays" action and try again, I think this is what breaks it!

Regards,
Max

[IMG]http://i58.tinypic.com/uplco.png[/IMG]

I removed the handle arrays action and the result of the debug is above.
Is that what you need?

It should update the record now, doesn't it ?

I think It tries to update, but the following error is geven: 1054 unknown column array in field list. The data which follows is indeed the data of the record to be updated.

I think its because you have some checkbox groups ? please try to remove them and test, if it works then please let me know and we will try to find a solution for this issue!

You are right. Without the checkboxes It works.

Is there already a solution for this problem?

Hi tvdgreft,

Apologies for not replying sooner!

Could you please send me a message using the "contact us" page to get a patch file to test ? and please include a link to this topic!

Regards,
Max

Hello,

I'm having the same problem here.
Handle array has been removed on the ON SUBMIT action.
Record is not updated and new empty record is added to table.
Debug is not showing unsual things.
Can anyone help with this please?



Regards,

SOLVED
I was using Id instead of id