Currently I have:
Expand|Select|Wrap|Line Numbers
- <%
- Set Conn = Server.CreateObject("ADODB.Connection")
- Conn.open "--connection information here--"
- SQL = "Select firstname,lastname from [names] order by lastname"
- Set RS = Conn.Execute(SQL)
- %>
- <table border=1>
- <tr>
- <th>Name</th>
- <th>Condition One</th>
- <th>Condition Two</th>
- <th>Condition Three</th>
- <th>Condition Four</th>
- </tr>
- <%
- Do While Not RS.EOF
- %>
- <tr>
- <td><%=RS("LastName")%>, <%=RS("FirstName")%></td>
- <td><input type="checkbox" name="input1"></td>
- <td><input type="checkbox" name="input2"></td>
- <td><input type="checkbox" name="input3"></td>
- <td><input type="checkbox" name="input4"></td>
- </tr>
- <%
- RS.MoveNext
- Loop
- %>
- </table>
"Request.Form("input1")" only retrieves the value "on" from the boxes that are checked and nothing from those that are not checked.
How can I get a "false" or "off" value from the ones that are not checked so I can put the collected data into the new table in a [name, val1, val2, val3, val4] kind of format.