'get directors
ajg_sQry = "SELECT top 100 staff.colleagueid, staff.stafftitle, "&_
"    staff.responsibility, staff.seniority, "&_
"    staff.displayrank, colleagues.firstname, "&_
"    colleagues.lastname, offices.webcity"&_
" FROM offices RIGHT OUTER JOIN"&_
"    colleagues ON "&_
"    offices.officeid = colleagues.officeid RIGHT OUTER JOIN"&_
"    staff ON "&_
"    colleagues.colleagueid = staff.colleagueid"&_
" WHERE (staff.seniority = 4) ORDER BY staff.displayrank"
ag_get_recordset ajg_sQry,30,iicnet
if ag_err(30)<>"" then
	'response.write ag_err(30)
end if

'get vice chairs
ajg_sQry = "SELECT top 100 staff.colleagueid, staff.stafftitle, "&_
"    staff.responsibility, staff.seniority, "&_
"    staff.displayrank, colleagues.firstname, "&_
"    colleagues.lastname, offices.webcity"&_
" FROM offices RIGHT OUTER JOIN"&_
"    colleagues ON "&_
"    offices.officeid = colleagues.officeid RIGHT OUTER JOIN"&_
"    staff ON "&_
"    colleagues.colleagueid = staff.colleagueid"&_
" WHERE (staff.seniority = 3) ORDER BY staff.displayrank"
ag_get_recordset ajg_sQry,31,iicnet
if ag_err(31)<>"" then
	'response.write ag_err(31)
end if

'get coo
ajg_sQry = "SELECT top 100 staff.colleagueid, staff.stafftitle, "&_
"    staff.responsibility, staff.seniority, "&_
"    staff.displayrank, colleagues.firstname, "&_
"    colleagues.lastname, offices_admin.webcity, offices_admin.officecountry"&_
" FROM offices_admin RIGHT OUTER JOIN"&_
"    colleagues ON "&_
"    offices_admin.officeid = colleagues.office_adminid RIGHT OUTER JOIN"&_
"    staff ON "&_
"    colleagues.colleagueid = staff.colleagueid"&_
" WHERE (staff.seniority = 2) ORDER BY staff.displayrank"
ag_get_recordset ajg_sQry,32,iicnet
if ag_err(32)<>"" then
	'response.write ag_err(32)
end if

'get staff
ajg_sQry = "SELECT top 100 staff.colleagueid, staff.stafftitle, "&_
"    staff.responsibility, staff.seniority, "&_
"    staff.displayrank, colleagues.firstname, "&_
"    colleagues.lastname, offices_admin.webcity, offices_admin.officecountry"&_
" FROM offices_admin RIGHT OUTER JOIN"&_
"    colleagues ON "&_
"    offices_admin.officeid = colleagues.office_adminid RIGHT OUTER JOIN"&_
"    staff ON "&_
"    colleagues.colleagueid = staff.colleagueid"&_
" WHERE (staff.seniority = 5) ORDER BY staff.displayrank"

'ajg_sQry = "SELECT top 100 staff.colleagueid, staff.stafftitle, "&_
'"    staff.responsibility, staff.seniority, "&_
'"    staff.displayrank, colleagues.firstname, "&_
'"    colleagues.lastname, offices.webcity"&_
'" FROM offices RIGHT OUTER JOIN"&_
'"    colleagues ON "&_
'"    offices.officeid = colleagues.officeid RIGHT OUTER JOIN"&_
'"    staff ON "&_
'"    colleagues.colleagueid = staff.colleagueid"&_
'" WHERE (staff.seniority = 5) ORDER BY staff.displayrank"
ag_get_recordset ajg_sQry,33,iicnet
if ag_err(33)<>"" then
	'response.write ag_err(33)
end if

'get chair person
ajg_sQry = "SELECT staff.colleagueid, staff.stafftitle, staff.responsibility, staff.seniority, staff.displayrank, colleagues.firstname, colleagues.lastname, offices.webcity"&_
" FROM offices RIGHT OUTER JOIN colleagues ON offices.officeid = colleagues.officeid RIGHT OUTER JOIN staff ON colleagues.colleagueid = staff.colleagueid"&_
" WHERE (staff.seniority = 1)"
ag_get_one_record ajg_sQry,34,iicnet
if ag_err(34)<>"" then
	'response.write ag_err(34)
end if

Response.write "<table border='0' cellspacing='0' cellpadding='1'>"
Response.write "<tr>"

Response.write "<td valign='top'><table width='100' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"&_
"<tr><td align='center' class='body0' style='text-align:center;border: 1px solid #000000;'><b>MEMBERS</b></td>"&_
"</tr></table></td>"

Response.write "<td valign='top'><img src='img/arrow_r.gif' width='20' height='20' /></td>"
Response.write "<td valign='top'>"

Response.write "<table width='150' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"
Response.write "<tr>"&_
"<td class='body0' style='border: 1px solid #000000;'><b>"&ag_recordfield(34,1)&"</b><br />"&ag_recordfield(34,5)&" "&ag_recordfield(34,6)&", "&ag_recordfield(34,7)&"</td>"&_
"</tr>"
Response.write "</table>"
Response.write "<table width='150' border='0' cellspacing='0' cellpadding='1'>"
Response.write "<tr>"
Response.write "<td align='center'><img src='img/arrow_d.gif' /></td>"
Response.write "</tr>"
Response.write "</table>"

Response.write "<table width='150' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"
for i = 0 to ag_recordcount(31)-1
Response.write "<tr>"
Response.write "<td class='body0' style='border: 1px solid #000000;'><b>"&ag_multifield(31,1,i)&"</b><br />"&ag_multifield(31,5,i)&" "&ag_multifield(31,6,i)&", "&ag_multifield(31,7,i)&"</td>"
Response.write "</tr>"
next
Response.write "</table>"

Response.write "</td>"
Response.write "<td valign='top'><img src='img/arrow_r.gif' width='20' height='20' /></td>"

Response.write "<td valign='top'>"
Response.write "<table width='200' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"
for i = 0 to ag_recordcount(30)-1
Response.write "<tr>"
Response.write "<td class='body0' style='border: 1px solid #000000;'><b>"&ag_multifield(30,1,i)&"</b><br />"&ag_multifield(30,5,i)&" "&ag_multifield(30,6,i)&", "&ag_multifield(30,7,i)&"</td>"
Response.write "</tr>"
next
Response.write "</table>"
Response.write "</td>"
Response.write "<td valign='top'><img src='img/arrow_r.gif' width='20' height='20' /></td>"
Response.write "<td valign='top'>"
Response.write "<table width='150' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"
Response.write "<tr>"
Response.write "<td class='body0' style='border: 1px solid #000000;'><b>"&ag_multifield(32,1,0)&"</b><br />"&ag_multifield(32,5,0)&" "&ag_multifield(32,6,0)&"<br>"&ag_multifield(32,7,0)&", "&ag_multifield(32,8,0)&"</td>"
Response.write "</tr>"
Response.write "</table>"
Response.write "<table width='150' border='0' cellspacing='0' cellpadding='1'>"
Response.write "<tr>"
Response.write "<td align='center'><img src='img/arrow_d.gif' /></td>"
Response.write "</tr>"
Response.write "</table>"
Response.write "<table width='150' border='1' cellspacing='0' cellpadding='4' style='border-collapse:collapse'>"
for i = 0 to ag_recordcount(33)-1
Response.write "<tr>"
Response.write "<td class='body0' style='border: 1px solid #000000;'><b>"&ag_multifield(33,1,i)&"</b><br />"&ag_multifield(33,5,i)&" "&ag_multifield(33,6,i)&"<br>"&ag_multifield(33,7,i)&", "&ag_multifield(33,8,i)&"</td>"
Response.write "</tr>"
next
Response.write "</table>"
Response.write "</td>"
Response.write "</tr></table>"