/* Check to make sure we are connected to the database before allowing access to the home page. If not connected, go connect and initialize; otherwise, welcome the user.\ */ if(!database.connected()) redirect("init.htm"); project.lock(); if (client.action == "insert") { database.execute("insert into beneficiary (employee_ssn, name1, relationship1, name2, relationship2) values (" + client.ssn + ", '" + request.name1 + "', '" + request.relationship1 + "', '" + request.name2 + "', '" + request.relationship2 + "')"); } else { database.execute("update beneficiary set name1 = '" + request.name1 + "', relationship1 = '" + request.relationship1 + "', name2 = '" + request.name2 + "', relationship2 = '" + request.relationship2 + "' where employee_ssn = " + client.ssn + ""); } database.execute("update status set cs5 = 'yes' where employee_ssn = " + client.ssn + ""); project.unlock(); redirect("areas.htm");