/* 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(); Employee Status

Below is a listing of employees who have completed the benefits enrollment process.

while(cursor.next()) { if (cursor.ssn == 0) { } else { } }
Name Social Security Number
write(cursor.name); write(cursor.ssn);

Return to Main Menu