On my site I have an area where up to 40 individual records consisting of several fields each are displayed and are able to be edited by the user. My customer insists that there be only one submit button on this page, not individual submits for each record. What I am trying to do is to minimise the number of database calls for updating records by only submitting records that have actually changed. What I have thought of doing is as follows, when the page is first loaded I concatanate all of the fields for each record into a string and build a structure/array of all of these strings. When the user has updated the records and submits the page I will build another structure/array in the same way. What I then need to do is to compare both structures/arrays to identify which records have actually changed and return those records only to be updated. Has anybody done anything similar to this? Do you know of any custom tags that will do the same? Is there a better way of doing this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
