Only update records that have changed - possible?
I am trying to only update records that have changed and not update the records that haven't changed. Is this possible?
The case is like this:
I have a list of questions for pupils - a1, a2. a3. ..... a28, a29.
They are able to access the page whenever they want to and they can choose witch questions they want to answer. They are able to answer the question with four answers - w1, w2, w3 or w4. But when they anser I want todays date to be stored in the same recordset with the answers and only on the questions that they change the answer on.
a1 - w2 - 03.03.2010
a2 - w2 - 03.03.2010
a3 - w3 : new value w1 - 07.03.2010
a4 - w3 - 03.03.2010
a8 - w1: new value w3 - 07.03.2010
I want only to update the questions where there is a new value in the answers and then automaticly store the date of today in these questions.
Is this possible with the multiple update function in DataAssist? I am thinking of using the onChange function with the questions answers (dynamic list) and then store the ids of the questions in an array to run the multiple update with. (Sorce: article11.asp)