/* 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();
cursor = database.cursor("select transaction.done, transaction.date_done, employee.ssn, employee.name from transaction, employee where transaction.done = 'yes' order by employee.name");
project.unlock();
Below is a listing of employees who have completed the benefits enrollment process.
Name |
Social Security Number |
while(cursor.next()) {
if (cursor.ssn == 0) {
} else {
write(cursor.name); |
write(cursor.ssn); |
}
}