sql database question
Do while not objRec.EOF
%>
<td><input type="text" name="selectme" size="90" value="<%=ObjRec("option_title")%>"></td>
<td> <% If ObjRec("cb") = "True" then %> <input type="checkbox" name="cb" value="checkflag" checked>
<% Else %> <input type="checkbox" name="cb" value="checkflag">
<% End If %> </td>
<%
objRec.movenext
loop
%>
The question i have is that this is a form and it is looping through my database and listing all the values from there in a textbox. When i change the value of one of the textbox and click update, it updates all of the values in my database because all of the textbox has the same name because of the loop.
I want to know how can i just update one of the textbox instaed of all of it. thanks.
|