Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /menu_pesquisa.asp, line 11
a linha 11 é esta :
set Rs = conexao.execute(sql)
e o codigo inteiro é este;
<!--#include file="conecta.asp"--> <!--#include file="topo.asp"--> <!--#include file="menu.asp"--> <TD COLSPAN=4 ROWSPAN=19> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; position: absolute; left: 185; top: 141" bordercolor="#111111" width="585" id="AutoNumber2" height="442"> <tr> <td width="100%"><p> <% AbreConexao Dim Sql, RS SQL = "SELECT * FROM geral WHERE id =" & request.querystring("id") & " ORDER BY nome ASC" set Rs = conexao.execute(sql) if not Rs.Eof then %> <% while not Rs.eof %> <font face="Verdana" size="2" color="#A12927"> <% response.write rs("nome") & "<br>" %></font> <font face="Verdana" size="2"> <% response.write rs("descricao") & "<br>" %> </font> <% response.write "<a href=""" & rs("link") & """>" & rs("link") & "</a><br><br>" Rs.MoveNext wend else %> <br> <br> <center><b> <font face=verdana> Nenhuma Empresa encontrada!</font><br></b></center> <% end if rs.close sql.close set rs=nothing FechaConexao %> </p></td> </tr> </table> </TD> </TR> <!--#include file="rodape.asp"-->
onde esta o erro?