<% Set dbConn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.RecordSet") dbConn.open Application("ConnectionString") %> RAM : Remaking American Medicine

<% 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 %>