snowboardr
Programmer
What would be the best way to delete multiple records using multiple checkboxes? I have looked on the web and stuff, and I am still not quite sure about checkboxes in ASP.
Thanks, Jason
Thanks, Jason
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
checkboxes
- Thread starter snowboardr
- Start date
- Status
Page 1
DIM deleteCount
deleteCount = 0
DO WHILE NOT rs.EOF
deleteCount = deleteCount + 1
%>
<input type="checkbox" name="del_<%= deleteCount %>" value="[PrimaryKey]">
<%
rs.MoveNext
LOOP
%>
<input type="hidden" name="totalRecords" value="<%= deleteCount %>">
Page 2
DIM i
FOR i = 1 TO Request.Form("totalRecords"
IF Request.Form("del_" & i) <> "" THEN
sql = "DELETE FROM Table WHERE [Primary Key] = " & Request.Form("del_" & i)
cn.Execute(sql)
END IF
NEXT
DIM deleteCount
deleteCount = 0
DO WHILE NOT rs.EOF
deleteCount = deleteCount + 1
%>
<input type="checkbox" name="del_<%= deleteCount %>" value="[PrimaryKey]">
<%
rs.MoveNext
LOOP
%>
<input type="hidden" name="totalRecords" value="<%= deleteCount %>">
Page 2
DIM i
FOR i = 1 TO Request.Form("totalRecords"
IF Request.Form("del_" & i) <> "" THEN
sql = "DELETE FROM Table WHERE [Primary Key] = " & Request.Form("del_" & i)
cn.Execute(sql)
END IF
NEXT
megalene
Programmer
- Jan 4, 2001
- 31
Or you could do this:
<form>
<input type=checkbox value=[primary key] name=pkey>[some filed here]<br>
<input type="submit" value="Delete">
</form>
IN ASP CODE
<%
dim pkey
pkey = split(request.form("pkey","'"
for x = 0 to ubound(pkey)
sql = "delete * from [my table] where primarykey=" & pkey(x)
myconn.execute(sql)
next
%>
This is less code and less form fields to filter and account for.
<form>
<input type=checkbox value=[primary key] name=pkey>[some filed here]<br>
<input type="submit" value="Delete">
</form>
IN ASP CODE
<%
dim pkey
pkey = split(request.form("pkey"
,"'"for x = 0 to ubound(pkey)
sql = "delete * from [my table] where primarykey=" & pkey(x)
myconn.execute(sql)
next
%>
This is less code and less form fields to filter and account for.
- Status
Similar threads
- Locked
- Question