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>