Optimizar una consulta sql

[edumferreyra]

Creo que tenés mal la ubicacion del next


key = request.form("keywords")
arrKey= split(key,",")
for i = 0 to ubound(arrKey)
key = trim(arrkey(i))
sql = "select * from kb_keywords where keyword like '%"&key&"%'"
set res = conn.execute(sql)

while not res.eof

if busqueda ="keyword" then
sql = "select * from kb_biblioteca where id_archivo = "&res("id_tema")&" "
set rs = conn.execute(sql)
while not rs.eof
response.write(rs("titulo"))
rs.movenext
wend
END IF
NEXT


Slds.