Delete an Author - Plain HTML <% if trim(request.form("auname")) = "" then %> <% dim oconn set oconn = server.createobject("adodb.connection") oconn.open("library2") %> <% dim oset set oset = oconn.execute("select * from authors order by auname") oset.movefirst %>

Filling in the form below will delete an author using ADO's SQL "pass-through technology".

Name

<% else %> <% dim oconn2 dim auname, sqlstmt auname = request.form("auname") set oconn2 = server.createobject("adodb.connection") oconn2.open "library2" sqlstmt = "Delete from authors where auname = '" & auname & "'" oconn2.execute(sqlstmt) %> <% end if %>
Go to home page