I am desperately in need of your help.
Any suggestion is greatly appreciated
I have html table populated with data from the database. I also have a checkbox that controls the visibility of a textarea. When this checkbox is checked a textarea will be visible and users can enter a note for each record. At the end of the table I have a button to save all the Modified records .
I need to capture the primary key of the record being updated
do while not objRSProject.eof -- getting data from the database
<td><input type=checkbox name="chk" onclick="getnext(this)"></td>
<%if Request.Form("chk") = 'on'
idid = objRSProject("id")
-- this gives the wrong primary key. This record's check box is not even checked
<td class="tdHidden"> <textarea rows="1" cols="50" name="Notes"></textarea> </td>
The above table have the primary key that I need to update my table.
<%If Request.Form("action") = "Update" Then 'This gives me the notes being entered
dim a , x
a = Split(Request.Form("Notes"), ",")
for each x in a
' response.Write(x )
' Here I will have my update statement but my problem is getting the primary key of the record that's being edited.