if (request.advid != null) { // create an updatable cursor on the ADVERTISER table. if (!dbCheck()) { redirect("../error.htm?error=dbfail"); } cursor = database.cursor("select * from advertiser where advid='" + request.advid + "'", true); cursor.next(); cursor.advname = request.advname; cursor.addr1 = request.addr1; cursor.addr2 = request.addr2; cursor.city = request.city; cursor.state = request.state; cursor.postalcode = request.postalcode; cursor.country = request.country; cursor.email = request.email; cursor.phone = request.phone; cursor.fax = request.fax; cursor.contactname = request.contactname; cursor.contactphone = request.contactphone; cursor.contactfax = request.contactfax; cursor.contactemail = request.contactemail; cursor.adurl = request.adurl; cursor.adtext = request.adtext; cursor.gifurl = request.gifurl; cursor.updateRow("ADVERTISER"); cursor.close(); } // END IF redirect("../profile/confirm.htm?type=advert");