// header();
 | Company Bulletins |
Search Results...
mode = request.mode;
if(mode == "search")
{ result_string = bull_db_string();
all_bulletins_cursor = database.cursor(result_string);
}
i = 0;
while(all_bulletins_cursor.next())
{
// this logic builds the active and expired dates which print after each bulletin
activationdate = all_bulletins_cursor.ac_mon + "/" + all_bulletins_cursor.ac_day + "/" + all_bulletins_cursor.ac_year;
expirationdate = all_bulletins_cursor.ex_mon + "/" + all_bulletins_cursor.ex_day + "/" + all_bulletins_cursor.ex_year ;
write(" ",all_bulletins_cursor.title); |
//The following row prints the active and expired dates for the bulletin.
write("Active: | ");
write(""+ activationdate +" | ");
write("Expiration: | ");
write(""+ expirationdate +" |
");
write(all_bulletins_cursor.content," "); |
i++;
}// end of while loop
if (i == 0)
{ write('Sorry. No bulletins matched your search criteria.');
}