%
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT DISTINCT canal FROM consulta1 ORDER BY canal"
rs.Open sql,strConn
country=request.form("canal")
%>
Base10 - Banco de Dados Web
.
<%
if country<>"" then
sql="SELECT * FROM consulta1 WHERE canal='" & country & "'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,strConn
%>