');
// 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())
{
');
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" */
{