Move a row from one table to another using sql and asp

Posted by admin in asp, sql on 10 24th, 2008 | no responses

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 =" & objGetForm("db_id") & ";"

cnnSimple.Execute strq cnnSimple.Execute strq1

No Comments »

No comments yet.