Hi:

I am trying to update or delete froma SQL database from the web. I have successfully retrieved all of database information. However, I would like to make the first column in the database a link. Once you click on the link you can either update or delete the record. I have searched everywhere for this and cannot find an answer that will work. Please help.


Thanks very much!!!!

Once the user clicks on the link, you can pass the ID value to another page and either delete the row (delete from <table> where id = idpassedin) OR querty the data base based on the id (selef from <table> where id = idpassedin) and bind the values to controls on a form so then can update. Then call and update statement (Update <table> where ID = idpassedin).

Does anybody know of any site where I can get an example?

Tee88, it's a querystring that you need to pass from page to page

There are some great sites with tons of Free examples.
Try www.asp101.com or www.4guysfromrolla.com

Code for the link containig the ID of the record you want to delete

<a href="DeleteOrders.asp?idOrder=<%response.write pIdOrder%>"style="font-family: Arial; color: #003366">Click here to Delete Order Number<%response.write pIDOrder%></a>

Or here is an example of Deleting a record. Your connection to the DB is in OpenDB.asp

<%
' Heather P 2001
' Details: Delete selected order
%>

<%
on error resume next

dim conntemp, rstemp, rstemp2, mySql

call openDb()
'Pulls ID of record you want to delete from form or link on previous page
pIdOrder = getUserInput(request.querystring("idOrder"),10)
'Error handling
if pIdOrder="" then
   response.redirect "message.asp?message=You must select the order you want to delete."
end if

' update orders record !

mySql="DELETE RECORD FROM orders1 WHERE idorder=" &pIdorder
set rstemp=conntemp.execute(mySQL)
'Error handling
if err.number <> 0 then
   response.redirect "supporterror.asp?error="& Server.Urlencode("Error in DeleteOrderExec2: "&Err.Description)
end if

response.redirect "message.asp?message=The order information has been deleted"
%>