/* 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");
namecursor = database.cursor("select name from employee where ssn = " + client.ssn + "", true);
namecursor.next();
Current Enrollee:
write(namecursor.name);
On this form, you may edit your dependent information.
if (request.ssn == "add") {
cursor = database.cursor("select * from dependent");
client.action = "insert";
} else {
cursor = database.cursor("select * from dependent where employee_ssn = " + client.ssn + " and ssn = " + request.ssn + "");
cursor.next();
client.action = "update";
}
dep_cursor = database.cursor("select * from dep_rel");