%
thememberid = session("number")
%>
<%
DB_CONNECTIONSTRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../../fpdb/membersinfo.mdb") & ";"
function dbconnect()
set dbconnect = server.createobject("adodb.connection")
dbconnect.open DB_CONNECTIONSTRING
end function
%>
<%
dim oConn, rs, irownum
'connect to the database
set oConn = dbconnect()
'get the member information
set rs = oConn.execute("SELECT distinct(memberid), Salutation, FirstName, LastName, Suffix, Address1, Address2, City, State, Zip, Country, Expiration_issue, email, homephone, workphone FROM members where MemberID ='"& thememberid &"'")
%>
<% session("Salutation") = rs("salutation") %>
<% session("FirstName") = rs("firstname") %>
<% session("LastName") = rs("lastname") %>
<% session("Suffix") = rs("suffix") %>
<% session("Address1") = rs("address1") %>
<% session("Address2") = rs("address2") %>
<% session("City") = rs("city") %>
<% session("State") = rs("state") %>
<% session("Zip") = rs("zip") %>
<% session("Country") = rs("country") %>
<% session("Expiration_issue") = rs("expiration_issue") %>
<% session("email") = rs("email") %>
<% session("homephone") = rs("homephone") %>
<% session("workphone") = rs("workphone") %>
 |
Southern Railway
Historical Association |
 |
|
<%
do until rs.eof
%>
|
<%
rs.movenext
loop
%>
|
|
 |
SRHA
Leadership |
 |
|
The
leadership
of
the
Association
consists
of
8
directors
who
are
elected
to
2
year
terms.
Each
year,
elections
are
held
for
4
of
the
director
positions.
The
current
Board
of
Directors
consists
of:
|
President
|
Rick Bell
(president@srha.net)
|
|
Vice President
|
Dick Kimball |
|
Secretary
|
Dick Fisher
|
|
Treasurer
|
Frank Greene
|
|
Directors
|
George
Eichelberger
|
|
|
John Schnieder (grab@srha.net)
|
|
|
Greg Soots |
|
|
Dan Sparks |
|
Legal Council |
Joe Bryson |
There
are
other
important
positions
held
by
other
members:
|
TIES Editor
|
Craig Myers (editor@srha.net) |
| Diesel Editor |
Marvin Black |
| Among Ourselves Editor |
Matt Bumgarner |
| TIES Production |
Craig Myers |
| Membership |
Dan Sparks (membership@srha.net) |
| Webmaster |
Dan Sparks (webmaster@srha.net) |
| Archives Director |
George Eichelberger (archives@srha.net) |
|
|
Click here for the by laws of the
association.
|
 |
|
 |
|
|
<%
rs.close
oconn.close
set rs = nothing
set oconn = nothing
%> |
|
Southern Railway Historical
Association
P. O. Box 33
Spencer, NC
28159 |
|