Ver Mensaje Individual
  #18 (permalink)  
Antiguo 27/12/2005, 08:03
Veronicalismar
 
Fecha de Ingreso: diciembre-2005
Mensajes: 131
Antigüedad: 19 años, 5 meses
Puntos: 0
Sentencia

Necesito una sentencia parecida a esta pero que funcione

<%
if request.QueryString ("nombre") = "argentina" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'argentina') AND (password = 'even2005') AND (nombre = 'argentina')"

elseif request.QueryString ("nombre") = "brazil" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'brazil') AND (password = 'even2005') AND (nombre = 'brazil')"

elseif request.QueryString ("nombre") = "colombia" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'colombia') AND (password = 'even2005') AND (nombre = 'colombia')"

elseif request.QueryString ("nombre") = "costa rica" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'costa rica') AND (password = 'even2005') AND (nombre = 'costa rica')"

elseif request.QueryString ("nombre") = "ecuador" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'ecuador') AND (password = 'even2005') AND (nombre = 'ecuador')"

elseif request.QueryString ("nombre") = "el salvador" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'el salvador') AND (password = 'even2005') AND (nombre = 'el salvador')"

elseif request.QueryString ("nombre") = "estados unidos" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'estados unidos') AND (password = 'even2005') AND (nombre = 'estados unidos')"

elseif request.QueryString ("nombe") = "mexico" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'mexico') AND (password = 'even2005') AND (nombre = 'mexico')"

elseif request.QueryString ("nombre") = "panama" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'panama') AND (password = 'even2005') AND (nombre = 'panama')"

elseif request.QueryString ("nombre") = "puerto rico" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'puerto rico') AND (password = 'even2005') AND (nombre = 'puerto rico')"

elseif request.QueryString ("nombre") = "republica dominicana" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'republica dominicana') AND (password = 'even2005') AND (nombre = 'republica dominicana')"

elseif request.QueryString ("nombre") = "venezuela" then
sql= "SELECT login, password, nombre FROM administrador WHERE (login = 'venenzuela') AND (password = 'even2005') AND (nombre = 'venezuela')"

else
sql = "select distinct area_v.cod_area, area_v.nom_area FROM area_v RIGHT JOIN curriculumv ON area_v.cod_area = curriculumv.cod_area"
end if
set rs = con.Execute(sql)
%>