can't change data in the canSynchronizeList event

[frankbicknell]

Can someone tell me the proper syntax to use to override the value of a field in the list control?

e.data.fieldName = xx does not work
nor does
e.data.fieldName.value = xx
or
e.data.[1].fieldName = xx etc, etc, etc.....


This is the help from the canSynchonizeList event of a list control.

Fires when the user tries to synchronize the data in the List (by making an Ajax callback). If function returns false, action is cancelled. The data object is passed in as a member of the e object. If you set properties in e.data, you can overrride the values from the List that will be submitted to the server. If you set the e.data[rowNumber]._isDirty property of a particular row to false, then the data in that row will not be synchronized. The e object that is passed in includes: batchSize, totalDirtyRows and startingRow. If all data is not being submitted in batches, batchSize is 0. To test if this is the first batch in a job test for batchSize > 0 and startingRow = 1

[Davidk]

Re: can't change data in the canSynchronizeList event

Specifically, the canSynchronizeList event is part of the Detail View, Client-side events... found under the Detail View tab.
Your main issue is that your posted code either doesn't use the e.data array or uses it improperly.

This works as detailed, but case matters. If your SQL Statement is pulling data as...

SELECT CUSTOMER_ID, FIRSTNAME, lastName, COMPANY FROM tblcustomers

and you want to override FIRSTNAME of the 1st row submitted, then your code will be...

e.data[0].FIRSTNAME = "myNewFirstName";

If you want to override lastName of the 2nd row submitted, then your code will be...

e.data[1].lastName = "New Last Name";

[frankbicknell]

Re: can't change data in the canSynchronizeList event

Thank you David. That zero based array structure gets me every time.

[frankbicknell]

Re: can't change data in the canSynchronizeList event

After looking at this again I was using the wrong event. I needed the canUpdateList event which allows me to override the value of the lists detail view fields directly with.
e.data.fieldName = fieldValue