%@ LANGUAGE="VBSCRIPT" %> <% Cat= request.querystring("cat") If Cat = "" then vCat = "" CatTitle = "Entire Listing" elseif Cat = "cChildCare" then vCat = "Where cChildCare = -1" CatTitle = "Child Care/School Age Topics" elseif Cat = "cImmunization" then vCat = "Where cImmunization = -1" CatTitle = "Immunization Topics" elseif Cat = "cPoisonPlants" then vCat = "Where cPoisonPlants = -1" CatTitle = "Poisonous Plants" elseif Cat = "cPrevention" then vCat = "Where cPrevention= -1" CatTitle = "Prevention Topics" elseif Cat = "cInstruction" then vCat = "Where cInstruction = -1" CatTitle = "Instructions" elseif Cat = "cNewborn" then vCat = "Where cNewBorn = -1" CatTitle = "NewBorn Topics" End If Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open healthConnection MySQL="Select id, Title from tblMedical " & vCat & " Order by Title" Set rs=MyConn.Execute(MySQL) If rs.eof or rs.bof then Else aTitles=rs.GetRows End If %>
![]() |
|
|
BP Home Meet Our Staff Office Information Map To Office Insurance Rainbow News Health Education Medical Links E-Mail Us Emergency Phone |
Health Education: <%= CatTitle %>
<% For row = 0 to UBound(aTitles,2) ' iterate through the rows in the variant array
vID = aTitles(0,row)
vTitle = aTitles(1,row)
%>
<%= vtitle %>
|