Multiple checkbox insert database

[Mokaka]

Hi Good people

I have the form ,users check many checkboxes they want based on the question they want to submit,I want to store values of the checkbox they chose as numbers,ie I have checkbox from one to ten,so if they have chosen one to five ,I have to store those values in the database.


[code]

<li class="file"><input type="checkbox" name="txtIncident" value="<%=Node.iCategoryId%>" class="treeview"><font size="-1" color="navy"><%=Node.Category_Desc%><%=Node.iCategoryId%></font>


SQLStmt = "INSERT INTO table (iId, iCategoryId) SELECT '" &iId& "', CATEGORY_NO FROM n_table WHERE CATEGORY_NO IN ('"&request.form("txtIncident"
[End code]

or some one can help me on how to insert multiple checkbox into the database in ASP

[yamaharuss]

Here is a sample of what I use.. in my application I have a dropdown which allows the user to select what action to take on the selected items.

strEditType = Request.QueryString("EditType")
	If strEditType = "itemschecked" then
		editCount = Request.QueryString("Count")
		doWhat = Request.QueryString("doWhat")
		for i = 0 to editCount-1
    sID = Request("itemchecked_" & i)
    if sID <> "" then

        SELECT CASE doWhat
        	CASE "Del" ' DELETE ORDER
        		sql = "DELETE From Orders WHERE OrderID = " & sID
        		Conn.Execute(sql)
        		sql = "DELETE From OrderItems WHERE OrderID = " & sID
        		Conn.Execute(sql)
        		Session("M") = "OrdersDeleted"
        		Response.Redirect("?View=Sales")
        	CASE "Read" ' MARK AS READ
        		sql = "Update Orders Set Viewed = 1  WHERE OrderID = " & sID
        		Conn.Execute(sql)
        		Session("M") = "OrdersMarkedRead"
        		Response.Redirect("?View=Sales")
        	CASE "UnRead" ' MARK AS UNREAD
        		sql = "Update Orders Set Viewed = 0  WHERE OrderID = " & sID 
        		Conn.Execute(sql)  
        		Session("M") = "OrdersMarkedUnread" 
        		Response.Redirect("?View=Sales")		
        END SELECT
    end if
next
	
	End If