|
2006-2007 Board of
Councilors
LSMS Leadership
The Louisiana State Medical Society Board of
Councilors is composed of the ten District Councilors, each occupying
a seat on the Board of Governors. The Board of Councilors acts upon
referred orders of business from the Board of Governors and serves as
the judicial body of the LSMS.
<%
dim conn, rs, username, password, qryString
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.open "eSeries_LSMS","sa","firewire"
qryString = "SELECT Activity.ID, Name.City, Name.COMPANY,Name.Last_Name, Name.FULL_NAME, Activity.ACTIVITY_TYPE, Activity.DESCRIPTION, Activity.TRANSACTION_DATE, Activity.EFFECTIVE_DATE, Activity.ACTION_CODES, Name.TITLE, Committee_Position.Title As Code FROM Activity INNER JOIN Name ON Activity.ID = Name.ID inner join Committee_Position on Activity.Action_codes = Committee_Position.Position_Code WHERE Activity.ACTIVITY_TYPE='committee' AND Activity.DESCRIPTION='Board of Councilors' AND Activity.EFFECTIVE_DATE <= GetDate() and Year(Activity.Thru_date) >= Year(GetDAte()) ORDER BY Committee_Position.Rank"
rs.open qryString, conn
rs.MoveFirst
do until rs.EOF
if rs("code") = "1st District Councilor" then
response.write("Board of Councilors | ")
response.write("" & rs("Code") & " | " & rs("Full_Name") & ", " & rs("City") & " | ")
else
response.write("" & rs("Code") & " | " & rs("Full_Name") & ", " & rs("City") & " | ")
end if
rs.movenext
Loop
%>
|
<%
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.open "eSeries_LSMS","sa","firewire"
qryString = "SELECT Activity.ID, Name.City, Name.COMPANY,Name.Last_Name, Name.FULL_NAME, Activity.ACTIVITY_TYPE, Activity.DESCRIPTION, Activity.TRANSACTION_DATE, Activity.EFFECTIVE_DATE, Activity.ACTION_CODES, Name.TITLE, Committee_Position.Title As Code FROM Activity INNER JOIN Name ON Activity.ID = Name.ID inner join Committee_Position on Activity.Action_codes = Committee_Position.Position_Code WHERE Activity.ACTIVITY_TYPE='committee' AND Activity.DESCRIPTION='BOG Alternates' AND Activity.EFFECTIVE_DATE <= GetDate() and Year(Activity.Thru_date) >= Year(GetDAte()) ORDER BY Committee_Position.Rank"
rs.open qryString, conn
dim x
x=0
rs.MoveFirst
do until x = 10
if rs("code") = "1st District Councilor" then
response.write("Board of Councilors Alternates | ")
response.write("" & rs("Code") & " | " & rs("Full_Name") & ", " & rs("City") & " | ")
else
response.write("" & rs("Code") & " | " & rs("Full_Name") & ", " & rs("City") & " | ")
end if
rs.movenext
x=x+1
Loop
%>
|
