Ver Mensaje Individual
  #2 (permalink)  
Antiguo 14/05/2009, 05:19
Avatar de Adler
Adler
Colaborador
 
Fecha de Ingreso: diciembre-2006
Mensajes: 4.671
Antigüedad: 18 años, 4 meses
Puntos: 126
Respuesta: validación de usuarios

Hola

Prueba a pasarle la función cuando recoges los párametros

Código asp:
Ver original
  1. <%
  2. FUNCTION corregirComillas( cadena )
  3. strNuevaCadena = Trim(cadena)
  4. strNuevaCadena = REPLACE( cadena, "'", "''")
  5. strNuevaCadena = REPLACE(strNuevaCadena, "<", "")
  6. strNuevaCadena = REPLACE(strNuevaCadena, ">", "")
  7. strNuevaCadena = REPLACE(strNuevaCadena, "%", "")
  8. strNuevaCadena = REPLACE(strNuevaCadena, "*", "")
  9. strNuevaCadena = REPLACE(strNuevaCadena, "INSERT INTO", "")
  10. strNuevaCadena = REPLACE(strNuevaCadena, "DELETE FROM", "")
  11. strNuevaCadena = REPLACE(strNuevaCadena, "IFRAME", "")
  12. corregirComillas = strNuevaCadena
  13. END FUNCTION
  14. %>
  15.  
  16. <%
  17. Dim nombre, clave
  18.  
  19. nombre=corregirComillas(Request.Form("nombre"))
  20. clave=corregirComillas(Request.Form("clave"))
  21.  
  22. Ssql10="select txt_usuario, txt_clave, cod_estado_inv from m_investigadores where (txt_usuario='"&nombre&"' and txt_clave='"&clave&" and cod_estado_inv=1);"

Por otro lado el filtrado se podría mejorar

Código asp:
Ver original
  1. str = lcase(str)
  2.         str = replace(str,"  "," ")
  3.         str = replace(str,"=","")
  4.         str = replace(str,"'","")
  5.         str = replace(str,"""""","")
  6.         str = replace(str," or ","")
  7.         str = replace(str," and ","")
  8.         str = replace(str,"(","")
  9.         str = replace(str,")","")
  10.         str = replace(str,"<","[")
  11.         str = replace(str,">","]")
  12.         str = replace(str,"having ","")
  13.         str = replace(str,"group by","")
  14.         str = replace(str,"union select sum","")
  15.         str = replace(str,"union select min","")
  16.         str = replace(str,"--","")
  17.         str = replace(str,"select ","")
  18.         str = replace(str,"insert ","")
  19.         str = replace(str,"update ","")
  20.         str = replace(str,"delete ","")
  21.         str = replace(str,"drop ","")
  22.         str = replace(str,"-shutdown","")

Suerte
__________________
Los formularios se envían/validan con un botón Submit
<input type="submit" value="Enviar" style="background-color:#0B5795; font:bold 10px verdana; color:#FFF;" />