I have a ul of text boxes. I want to loop through the list elements and post their values to an Access database. How can I do this in asp? Here is my current attempt. rsAwards is my recordset, my connection object is named dataCon. I'm looking for a loop that will post all the values of the text boxes within the unordered list. As you can see the list is populated dynamical from the database.
Set dataCon = Server.CreateObject("ADODB.Connection")
Set rsAwards = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM Awards"
rsAwards.Open strSQL, dataCon
<form name="sort_award" action="action_awards.asp?Action=sort&Award_ID=<%=Award_ID%>" method="post">
response.write "<ul id='sortable'>"
While not rsAwards.EOF
response.write "<li onclick='sort()'><input type='text' id='AwardNum' size='1' value="&i&" ></li>"