% Set dbConn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.RecordSet") dbConn.open Application("ConnectionString") %>
<%
SQL="[sp_CWO_Details] " & request.querystring("ID")
rs.open SQL, dbConn
if not rs.eof then
%>
<%= rs("organizationName") %>
<%= rs("address") %>
<%= rs("city") %>, <%= UCase(rs("state")) %> <%= rs("zipCode") %>
Phone: <%= rs("organizationPhone") %>
URL: ', 'externalSite','')}"><%= rs("URL") %>
Contact: <%= rs("contactFirstName") %> <%= rs("contactLastName") %>
Contact Phone: <%= rs("contactPhone") %>
Contact Email: <%= rs("contactEmail") %>
Region: <%= rs("region") %>
Organization Type: <%= rs("OrgTypeList") %>
Health Care Issues: <%= rs("HCI_List") %>
Audience: <%= rs("AudienceList") %>
<% if rs("missionStatement") <> "" then %>
Mission Statement:
<%=rs("missionStatement") %>
<% end if %>
<%
end if
%>