MA events are designed to expose members to the myriad of marketing
opportunities available, as well as provide a forum for strong relationship
building both within Merage as well as the outside business community.
Plus, we like to have fun.
<%
set conn = server.createobject("ADODB.Connection")
conn.open "Marketing"
SQL="Select * from events where eventtype = '1' ORDER BY ID DESC"
set rs=conn.execute(SQL)
do while not rs.eof
Response.write("")
Response.write(rs(1) & "")
if (rs(2) <> "") then
Response.write(" - ")
Response.write(rs(2) & "/")
Response.write(rs(14) & "/")
Response.write(rs(16))
else
Response.write(" - TBD")
end if
Response.write("
")
Response.write(rs(8) & " ")
Response.write(rs(3))
Response.write(rs(12))
Response.write(rs(13) & " ")
if (rs(5) <> "") then
Response.write("
When: ")
Response.write(rs(5) & "-")
Response.write(rs(15))
end if
if (rs(6) <> "") then
Response.write("
Where: ")
Response.write(rs(6))
end if
if (rs(7) <> "") then
Response.write("
Signup: ")
Response.write(rs(7))
end if
Response.write("
")
if (rs(9) <> "") then
response.write("[ ")
Response.write(rs(4) & "")
if (rs(10) <> "") then
Response.write(" | ")
Response.write(rs(10) & "")
end if
if (rs(19) <> "") then
Response.write(" | ")
Response.write(rs(19) & "")
end if
Response.write(" ] ")
end if
Response.write(" ")
rs.movenext
loop
set rs=nothing
conn.close
%>
<%
set conn = server.createobject("ADODB.Connection")
conn.open "Marketing"
SQL="Select * from events where eventtype = '2' ORDER BY ID DESC"
set rs=conn.execute(SQL)
do while not rs.eof
Response.write("")
Response.write(rs(1) & "")
if (rs(2) <> "") then
Response.write(" - ")
Response.write(rs(2) & "/")
Response.write(rs(14) & "/")
Response.write(rs(16))
else
Response.write(" - TBD")
end if
Response.write("
")
Response.write(rs(8) & " ")
Response.write(rs(3))
Response.write(rs(12))
Response.write(rs(13) & " ")
if (rs(5) <> "") then
Response.write("
When: ")
Response.write(rs(5) & "-")
Response.write(rs(15))
end if
if (rs(6) <> "") then
Response.write("
Where: ")
Response.write(rs(6))
end if
if (rs(7) <> "") then
Response.write("
Signup: ")
Response.write(rs(7))
end if
Response.write("
")
if (rs(9) <> "") then
response.write("[ ")
Response.write(rs(4) & "")
if (rs(10) <> "") then
Response.write(" | ")
Response.write(rs(10) & "")
end if
if (rs(19) <> "") then
Response.write(" | ")
Response.write(rs(19) & "")
end if
Response.write(" ] ")
end if
Response.write(" ")
rs.movenext
loop
set rs=nothing
conn.close
%>
 Back to top
|
Home
