<%
if request("yes") <> "" then
cnn.execute "DELETE FROM tbl_oline WHERE id=" & request("id")
cnn.close
set cnn = nothing
response.redirect "menu.asp"
else
set rs = server.createobject("adodb.recordset")
sql = "SELECT tbl_oline.*, tbl_product.name AS product_name " & _
"FROM tbl_oline " & _
"LEFT JOIN tbl_product ON tbl_oline.product_id=tbl_product.id " & _
"WHERE order_id=" & session("order_id")
rs.open sql, cnn, 1, 3
name = rs("product_name")
label = rs("label")
rs.close
set rs = nothing
end if
%>
Remove Order Line
Are you sure you want to remove the
<%=name%> for <%=label%>?
&yes=1" style="font-weight:bold;color=black">Yes
No