Home » 2011 » September » 24

Archive for September 24, 2011

Classic asp delete script

September 24, 2011 - Posted in Classic ASP - Permalink

<% ‘define variables DIM objConn, objRS ‘connection DIM i_last, count, bgcolor ‘even row bg color Dim job, recID ‘fetching query strings job = Request.QueryString(“do”) recID = Request.QueryString(“rid”) Dim sqlstatement ‘ sql query command string If job = “del” Then SET objConn = Server.CreateObject(“ADODB.Connection”) objConn.ConnectionTimeOut = 30 objConn.Open “DSN=MySystemDSN” sqlstatement = “DELETE FROM Customers WHERE ID=” […]