I am working on a Classic ASP project where I am updating multiple records in a table with single Submit button. Each row has select box and text box and user can update all the rows. While sending parameters to stored procedure , I want to pass only those values where input values ( select box or text box ) have been changed. I can't figure how should I do that. sCycleTime(Id) and sComment(id) contains values of Select Box and Textbox of all the rows. sProfile(id) and sProcess_Step_Sequence(Id) are two id's binded in each Select box and Textbox. Eg: DrpDwn_1_4 and Txtbox_1_4 and so on...
Code:
sQry = ""
For Id = 0 to 22
response.Write ("this is " & l_comments)
If Trim(sProcess_Step_Sequence (Id)) <> "" Then
If Trim(sQry) = "" Then
sQry = sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id) & "^" & sComment(id)
Else
sQry = sQry & "!" & sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id)& "^" & sComment(id)
End If
End If
Next
objCommand.CommandText = "EXEC usp_UPDATE_Dual_Code_Cycle_Times_and_Comments '" & sQry & "' ; "