Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaustin817
Starting Member
12 Posts |
 Posted - 2001-10-14 : 23:53:08
|
| The below code pulls back data from the db, I am trying to update each of these records from a form page at one time. Then I want to post the information to the db. My question is: The meter field will be updated on this form. But the name is "meter" and this form pulls back 500 records. When I post to the next form, My variable is set to request.form("meter") and then I do an update. How can get the updated information from all 500 records to get updated with one submit?<form method="post" action="new_meter_pro.asp"> <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#111111" width="65%" id="AutoNumber1"> <tr> <td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Auto ID</b></td> <td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Customer ID</b></td> <td width="20%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Customer Name</b></td> <td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>PO</b></td> <td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Machine</b></td> <td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Card Date</b></td><td width="5%" bgcolor="#CCCCCC" bordercolor="#000000"><b>Meter</b></td> </tr> <% if rs.eof=true then response.write("</table>" & "<b>No Open Calls</b>" & "<table><br>")elsedo while not rs.eof%><% response.write ("<tr><td align=center>")%> <input size=10 name="aid" value="<% Response.Write rs.fields("autonumber") %>" onfocus="blur()"> <% response.write("</td>")%><% response.write ("<td align=center>")& rs.fields("cid") & response.write("</td>")%><% response.write ("<td>") & rs.fields("name") & response.write("</td>")%><% response.write ("<td>") & rs.fields("po") & response.write("</td>")%><% response.write ("<td align=center>") & rs.fields("machine") & response.write("</td>")%><% response.write ("<td align=center>") & rs.fields("cdate") & response.write("</td>")%><% response.write ("<td align=center>")%> <input size=10 name="meter" value=""> <% response.write("</td>")%><% response.write ("<td align=center>")%><input type=submit size=5 name="submit" value="Ok"><% response.write("</td>")%><%rs.movenextloopend if %></table> |
|
|
|
|
|
looping insert from form