Delete selected information from database from table

**Arshan** · Arshan, September 2nd, 2009 10:17 AM

Hi,

I have a small database that keeps track of time off request. I am using ASP for it. What I need to do is add a button or check box that allows a person to delete one of the requests.

I could do this with a drop down menu, but that isn't user friendly enough. Is there a way to add a button or checkbox to each row that would allow the user to select a the info from that field in the table and delete it in the database?

I know the code to delete entries, all I would need is the way to add a button/checkbox at each stage, and how to use it to identify the data to be deleted.

Here is what I have to create the table and get the information:

Code:

<%@ Language=VBScript %>
<%Option explicit
Dim oRs, conn, connect, strSQL

set conn=server.CreateObject ("adodb.connection")
connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\data\users.mdb") & ";Persist Security Info=False"
conn.Open connect %>


<html>
<head>
	<script language="JavaScript" src="calendar_us.js"></script>
	<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>


<title> PTO Reqeust Information </title>



</head>
<body>



</form>

<table width="100%" border="1" >

<tr>

<%

dim mynumber
mynumber = request.form("number")

	Set oRs=Server.CreateObject("adodb.recordset")
		strSQL = "SELECT * FROM Pto_TBL WHERE Number = '" & mynumber & "'"
        oRs.Open strSQL, conn


              Response.Write  ("<td>") &("ID Number: ")  & ("<td>") &  ("Start Date: ") & ("<td>") & ("End Date: ") &  ("<td>") & ("Hours used: ")& ("<td>")
		Do while not oRs.EOF

			Response.Write  ("<td>")  & oRS("ID") & ("<td>") &  oRS("StartDate") & ("<td>")  & oRS("EndDate") &  ("<td>")  & oRS("hours") & ("<td>")
	        Response.Write("<tr>")
		    oRs.MoveNext


	loop
	%>


</table>


</body>
</html>

Number is from the previous page, that they enter. If there are any other questions let me know. Thanks for your help.

**richyrich** · richyrich, September 2nd, 2009 11:01 AM

Your HTML doesn't look at all well formatted. You are missing end tags from your <tr> and <td> tags. You have a closing </form> tag but no opening tag.

The easiest way to do this with this layout is to just add a hyperlink that passes the ID to a page that runs the delete code and then redirects back to this page.

Code:

 	Do while not oRs.EOF

			Response.Write  ("<tr><td><a id=""link" & oRS("ID") & """ href=""deletePage.asp?ID=" & oRS("ID") & """>Delete</a></td><td>"  & oRS("ID") & "</td><td>" &  oRS("StartDate") & "</td><td>" & oRS("EndDate") &  "</td><td>"  & oRS("hours") & ("</td></tr>")
      oRs.MoveNext

I've tried to tidy up the tags somewhat as well. Then on your delete page just retrieve the ID querystring and use that to delete the entry from the db.

Hope that helps.

**Arshan** · Arshan, September 2nd, 2009 11:17 AM

Originally Posted by richyrich

Your HTML doesn't look at all well formatted. You are missing end tags from your <tr> and <td> tags. You have a closing </form> tag but no opening tag.

The easiest way to do this with this layout is to just add a hyperlink that passes the ID to a page that runs the delete code and then redirects back to this page.

Code:

 	Do while not oRs.EOF

			Response.Write  ("<tr><td><a id=""link" & oRS("ID") & """ href=""deletePage.asp?ID=" & oRS("ID") & """>Delete</a></td><td>"  & oRS("ID") & "</td><td>" &  oRS("StartDate") & "</td><td>" & oRS("EndDate") &  "</td><td>"  & oRS("hours") & ("</td></tr>")
      oRs.MoveNext

I've tried to tidy up the tags somewhat as well. Then on your delete page just retrieve the ID querystring and use that to delete the entry from the db.

Hope that helps.

Thank you, I'll give it a shot. I'm sure you can tell this is my second day with HTML and ASP. I was surprised I got that far.

**richyrich** · richyrich, September 2nd, 2009 11:27 AM

Ah...OK...In which case I'd probably redo your page to include the whole lot inside <form></form> elements and then use a seperate checkbox for each entry, giving each the same name, and a value of the ID.

Add a button to submit the form and then use request.form("checkBoxName") which will give a comma seperated list of all the checkbox values that were ticked.

Hope that makes sense.

Thread: Delete selected information from database from table

LinkBack

Thread Tools

Display

Delete selected information from database from table

Similar Threads

Check box pop up information??

Delete all records in table (syntax) then re-pop

Database table design

Database accessbility information

Getting data from a selected row in a gridview

Bookmarks

Bookmarks

Posting Permissions