Microsoft JET Database Engine (0x80040E14)
Errore di sintassi nella proposizione FROM.
/maniace/controllo.asp, line 27


ecco lo script:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
A:link {
COLOR: 000000; TEXT-DECORATION: underlined
}
A:visited {
COLOR: 000000; TEXT-DECORATION: none
}
A:hover {
COLOR: 999999; TEXT-DECORATION: none
}
</style>
</head>

<body>

<%
user = request.Form("user")
password = request.Form("password")

sql = "SELECT * FROM user"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql, conn, 3,3

if rs("user") = user and rs("password") = password then
Response.Cookies("comune")("password") = "si"

rs.Close
set rs = Nothing

response.redirect "admin/admin.asp"

else
%>
<table width="300" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td bgcolor="#CCCC33"><table width="300" border="0" align="center" cellpadding="3" cellspacing="0">
<tr bgcolor="#CCCC33">
<td width="282"> <div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">AREA
RISERVATA</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="105">
<div align="center">[img]img/area_riservata.gif[/img]

<font size="2" face="Verdana, Arial, Helvetica, sans-serif">

I dati inseriti non sono corretti!</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="40"> <div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="area_riservata.asp">Digita
nuovamente User e Password</a></font></div></td>
</tr>
</table></td>
</tr>
</table>
<%

rs.Close
set rs = Nothing

end if

%>
</body>
</html>