
27/12/2005, 08:03
|
| | 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)
%> |