Select your nearest country for a distributor listing

<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DataFlex Test32" sql="select country from dealers2 where password < 'U' group by country" Set RS = Conn.Execute(sql) i = 0 %> <% Do While not RS.eof %> <% i = i + 1 %> <% if i = 1 then %> <% end if %> <% if i = 3 then i = 0 %> <% RS.MoveNext Loop RS.close Conn.close %> <% if i = 0 then %> <% end if %>
<% cctest = RS("country") %> <% ' take out exces spaces from end %> <% cctest = trim(cctest) %> <% ' replace internal spaces with plus signs %> <% cctest2 = Replace(cctest," ","+") %> <% =cctest %>
OTHER COUNTRY

Note: The list of countries on this page was generated live from a DataFlex data file on this NT Server machine using Flex/ODBC. Contact your dealer to see how easily your data can appear instantly on the Internet!

----------

Home Search Feedback