|
|
North
Columbus Chapter Membership
| Name |
Company |
Category |
|
<%
Set conn = server.CreateObject("adodb.connection")
conn.Open "npi"
set rs = server.CreateObject("adodb.recordset")
rs.Open "select * from members order by lname",conn
while not rs.eof
Response.Write "| " & rs.fields("lname") & ", " & rs.Fields("fname") & " | " & chr(10)
if rs.Fields("company") <> "" Then
if rs.Fields("website") <> "" Then
Response.Write "" & rs.Fields("company") & " | " & chr(10)
else
Response.Write "" & rs.Fields("company") & " | " & chr(10)
end if
else
Response.Write " | " & chr(10)
end if
Response.Write "" & rs.Fields("cat") & " | " & chr(10)
rs.movenext
wend
rs.Close
conn.Close
%>
|
|