Tipo de erro:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][Driver ODBC para Microsoft Access] Erro de sintaxe (operador faltando) na expressão de consulta 'liberar='.
/news/Untitled-2.asp, line 11
Tipo de navegador:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Página:
GET /news/Untitled-2.asp
O codigo é esse
agradeço a ajuda
<%
cnpath="DBQ=" & Server.MapPath("noticias.mdb")
DataSource = "Driver={Microsoft Access Driver (*.mdb)}; " & cnpath
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DataSource
Set RS = Server.CreateObject( "ADODB.Recordset" )
RS.ActiveConnection = conn
'RS.open "SELECT * FROM Noticias"
RS.open "select *from Noticias where liberar="&sim&""
%>
<html>
<head>
<title></title>
</head>
<%
if not rs.eof then
while not rs.eof
%>
<table width="100%" cellspacing="2">
<tr>
<td><MARQUEE behavior=left><a href="ver.asp?id=<%=rs("id")%>"><%=rs("manchete")%></a><br><br></MARQUEE></td>
<%
rs.Movenext
wend
end if
%>
</tr>
</table>
</body>
</html>
