<% id=Request.Form("id") item_number=Request.Form("item_number") product_name=Request.Form("product_name") file_path=Request.Form("file_path") product_price=Request.Form("product_price") product_qty=Request.Form("product_qty") set edit = server.createobject("ADODB.Command") edit.activeconnection = strDB edit.commandtext = "UPDATE Products SET Item_Number = '" & item_number & "', Product_name = '" & product_name & "', File_Path = '" & file_path & _ "', Product_Price = '" & product_price & "', Product_qty = " & product_qty & " WHERE id LIKE '" & id & "'" edit.execute edit.activeconnection.close set edit = nothing Response.Redirect "products.asp" %>