PDA

Click to See Complete Forum and Search --> : deleting emails from access database


kovan
Sep 29th, 2000, 10:58 AM
after you hit submit..
send it to another asp, via request.form("name")...

in the second asp (where the form is sending information)
catch the parameters being sent in (email and name)
and do a search with sql something like

EmailAddy = request.form("EmailAddress")
SQLstatment ="SELECT * FROM EmailList WHERE EmailAddress = '" & EmailAddy & "'"
rs.open SQLstatement, db
if rs.eof then
response.write "Email Address not found in database.."
else
response.write rs("EmailAddress") & " " & rs("Name")
'put a delete link here.. when they hit that link, either send them to another page where delete happens, or withing the asp page write a function to do the deleting...
end if

kovan
Oct 3rd, 2000, 07:51 AM
check your email