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>
Rispondi quotando
