" maxlength="50" style="vertical-align:top; width:140px">
<%
dim rsTherapy
Set rsTherapy = CreateObject("ADODB.RecordSet")
strSQL="Select distinct therapy from tbl_products where therapy!='' and therapy!='NA' and therapy!='Not Applicable' and countrygeography='India' order by therapy asc "
rsTherapy.Open strSQL, oConn, 1, 3
'rsTherapy.close
%>
Therapy
<%
dim rsCountry
Set rsCountry = CreateObject("ADODB.RecordSet")
strSQL="Select distinct countryGeography from tbl_products where countryGeography!='' order by countryGeography asc"
rsCountry.Open strSQL, oConn, 1, 3
%>