Recent content by JustWondering

snowboardr, I have tried your way yet but How do I get the strChecked or strUnChecked? <%Do While NOT RsData.EOF%> <tr> <td><input type=&quot;hidden&quot; <td>Status<input type=&quot;checkbox&quot; name=&quot;chkStatus&quot...

Thank you so much GacyC123. It really works this time.

Since you change the checkbox name to chkStatus<%=rs(&quot;ID&quot;)%> The For loop need to change to: For i=1 to Request(&quot;chkStatus<%=RsData(&quot;TaskID&quot;)%>&quot;).count but it gave me syntax error

Actually, I use this to update: for i=1 to request(&quot;chkStatus&quot;).count SQL=&quot;Update Table Set Status = &quot; & CInt(Request(&quot;chkStatus&quot;)(i)) & &quot; Where ID = &quot; & CInt(Request(&quot;txtID&quot;)(i)) cn.execute mysql

Select * from Table where Status = 0 Items to be displayed: ID Status 55 0 68 0 77 0 The IDs are displayed in as lable, Status as checkboxes. User can update the table by checking the box.

Yes, the value of status is o 0r 1 in the table. However, my SQL statement only those that have Status = 0 to display. SQL=&quot;Select from Table where Status=0&quot; Let say it returns 10 records. Now user check 5 of them. The Update statement should update the right 5 records. Right now, it...

The values of all the checkboxes when the form is load are zeros. If the a box is check, how can I change its value to zero? <%Do While NOT RsData.EOF%> <tr><td>Status<input type=&quot;checkbox&quot; name=&quot;chkStatus&quot; value=0> <%RsData.MoveNext Loop%>

I think the value of the checkbox was lost. When I check the box and try to catch its value, it return False or 0.

Thanks for all the inputs. Each job and status are fileds in a record. ID Job# Status Date All the records are displayed in 1 form with same submit button. CInt(Request(&quot;chkStatus&quot; & i)) : This won't work either.

I also tried this: for i=1 to request(&quot;chkStatus&quot;).count SQL=&quot;Update Table Set Status = &quot; & CInt(Request(&quot;chkStatus&quot;)(i)) & &quot; Where ID = &quot; & CInt(Request(&quot;txtID&quot;)(i)) cn.execute mysql ...not working...Anyone know why???

Thank you kifaro. Your code works great!

Let me explain what I'm trying to achieve. First I select and display those records which have the Status=0. Job5 Status=0 Job7 Status=0 Job11 Status=0 Then I update them, depends on their values if users checked them or not. Each records has a ID. And I'm trying to update each records based...

Thank you for your response. Yes, they are all in a form. The form is in a table. And I have submit button to do the update. The method=post action=samepage.

Hi, I have an SQL update based on the value of the checkboxes: SQL=&quot;Update Table Set Status = &quot; & CInt(Request(&quot;chkStatus&quot;)) & &quot; Where ID = &quot; & IntID But I couldn't get the value of the checkboxes. I always update with checkbox's value = 0. Here is my...

So the answer is NO. Thank you.