This may be what you're looking for... http://cflib.org/udf.cfm?id=1136&enable=1
On 5/31/06, Andy Mcshane <[EMAIL PROTECTED]> wrote: > 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:241788 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
