if (request.advid != null) { // create an updatable cursor on the ADVERTISER table. if (!dbCheck()) { redirect("../error.htm?error=dbfail"); } cursor = database.cursor("select active from advertiser where advid='" + request.advid + "'", true); cursor.next(); if (cursor.active == "Y") cursor.active = "N" else cursor.active = "Y" cursor.updateRow("ADVERTISER"); cursor.close(); } // END IF redirect("adacct.htm");