I am going nuts trying to figure out the best way to handle my post data.
The user recieves row upon row of records each associated with a uniqueID.
Each record may contain 10 edittable fields. By default all fields are disabled.
He can enables the fields for the record he wishes to edit.
Each record may have multiple text, select and radio controls.
Upon submit I am only getting the data which needs to change - but thats where i get stuck. I wish you could post an array straight to vbscript, if so i would could use that as a guide [uniqueID] to loop through all my request.form elements and run an update sub on each in turn.
Currently I am appending each input control with the uniqueID.
So the server may recieve 6 request.form elements such as.
var1+uniqueID
var1+uniqueID
var2+uniqueID
var2+uniqueID
var3+uniqueID
var3+uniqueID
Of course the unique ID is also the primary key that I will use to specify WHERE during my MSSQL UPDATE.
Any advice on how I can intelligently process this dynamic data coming from the client back to the server is soooo greatly appreciated.