12/08/2004, 22:15
|
 | | | Fecha de Ingreso: mayo-2002 Ubicación: Lima, Peru
Mensajes: 4.619
Antigüedad: 23 años Puntos: 7 | |
| Deberia ser
if cate="2" or cate="1" then
subin="SELECT * FROM not"
elseif cate="3" or cate="1" then
subia="SELECT * FROM actividades"
elseif cate="4" or cate="1" then
subix="SELECT * FROM articulos"
end if
if len(subin)>0 then strsqln = subin& "where UCase(tit) like '%" & UCase(Request("tit")) & "%' AND UCase(artic) like '%" & UCase(Request("artic")) & "%' AND UCase(tex) like '%" & UCase(Request("tex")) & "%'"
if len(subia)>0 then strsqla = subia& "where UCase(tit) like '%" & UCase(Request("tit")) & "%' AND UCase(artic) like '%" & UCase(Request("artic")) & "%' AND UCase(tex) like '%" & UCase(Request("tex")) & "%'"
if len(subix)>0 then strsqlx = subia& "where UCase(tit) like '%" & UCase(Request("tit")) & "%' AND UCase(artic) like '%" & UCase(Request("artic")) & "%' AND UCase(tex) like '%" & UCase(Request("tex")) & "%'"
if cate="1" then
strsql=strsqln & " UNION " & strsqla & " UNION " & strsqlx
elseif cate="2" then
strsql=strsqln
elseif cate="3" then
strsql=strsqla
else
strsql=strsqlx
end if |