This code will show you how to move a row from one table to another using ASP. This involves delete and insert into.
strq = "INSERT INTO archive SELECT * FROM user_requests WHERE db_id =" & objGetForm("db_id") & ";"
strq1 = "DELETE FROM user_requests WHERE db_id =" &...
Move a row from one tab...
Delete command in sql u...
This shows you how to delete a row in sql using asp.
strq = "DELETE FROM general_census WHERE db_id = " & db_id & ";"
cnnSimple.Execute strq
SHARETHIS.addEntry({ title: "Delete command in sql using asp", url: "http://code.netexceed.com/asp/delete-command-in-sql-using-asp/"...

