Ciao a tutti,
Ho un problema con questa pagina, non riesco a capire dove sbaglio...
In pratica la pagina deve tirarmi su i record collegati ai due campi del form....
<%
' Get Search Phrase
user_id = TRIM( Request( "user_id" ) )
password = TRIM( Request( "password" ) )
' Open Database Connection
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "Select"
%>
<html>
<head>
<title>Documento senza titolo</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form method = "post" action="autenticazione.asp" >
<input name = "user_id" size="30">
<input name="password" size="30">
<input type="submit" value="Search">
</form>
<%
sqlstring = "select * from User where user_id = 'user_id' AND password = 'password' "
SET RS = Con.execute( sqlstring )
IF NOT RS.EOF AND user_id <> "" AND password <> "" THEN
%>
</p>
<table width="200" border="1">
<tr>
<th scope="col">Utente</th>
<th scope="col">Pool</th>
<th scope="col">Fascia</th>
</tr>
<%
WHILE NOT RS.EOF
%>
<tr>
<td><%=RS( "Nome Utente" ) %></td>
<td><%=RS( "Pool" ) %></td>
<td><%=RS( "Fascia" ) %></td>
</tr>
<%
rs.movenext
wend
%>
</table>
<%
else
%>
Nessun Risultato Trovato</p>
<%
END IF
%>
</body>
</html>