External Links

List of External Links


if (request.mode != "search") {

External Links for All Interest Groups

write(''); // this first cursor returns bulletins for interest group = all which are valide for today's date. cursor = database.cursor("select url,competitorname,description,interestgroupid from competitor where interestgroupid = '1' AND activationdate <= TODAY AND expirationdate >= TODAY order by competitorname"); while(cursor.next()) { } //end of while loop write ('
write(cursor.competitorname);
write(cursor.description);
'); if (client.interestgroupid != 1) /* The following cursor returns the user's interest group name to print in the link header. This logic is not performed if the user's interest group = "all" */ { cursor = database.cursor("select interestgroupid,interestgroup from interestgroup where interestgroupid = '" + client.interestgroupid + "'"); cursor.next(); write("

External Links for Interest Group: " + cursor.interestgroup + "

"); write(''); cursor = database.cursor("select url,competitorname,description,interestgroupid from competitor where interestgroupid = '" + client.interestgroupid + "' AND activationdate <= TODAY AND expirationdate >= TODAY order by competitorname"); while(cursor.next()) /* the next cursor returns links specific to the user's interest group. This logic is not performed if the user's interest group = "all" */ { } write('
write(cursor.competitorname);
write(cursor.description);

'); } } else { write('

Search Results...

'); result_string = comp_db_string(); cursor = database.cursor(result_string); write(''); var i = 0; while(cursor.next()) { i++; } if (i == 0) {write(''); } write('
write(cursor.competitorname);
write(cursor.description);
Sorry. No External Links matched your search criteria.

'); }