Microsoft OLE DB Provider for ODBC Drivers
  错误 '80040e10'
 

[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
 

行 set rs=conn.execute("SELECT top 100 NClassID,NClass,top FROM NClass order by top desc")

请问这段ASP代码有什么问题

<ul>
<%     
i=1      
MaxList=100
set rs=server.createobject("adodb.recordset")     
set rs=conn.execute("SELECT top 100 NClassID,NClass,top FROM NClass order by top desc")
rs.Open sql,conn,1,1
do while not rs.eof     
i=i+1
%>
<li class="gs gs_t rl">
<a target="_blank" href="Albumlist/<%=rs("NClassid")%>.htm"><%rs("NClass")%></a>
</li>
<%     
if i>=MaxList then exit do     
rs.movenext     
loop     
rs.close     
%>
</ul>

[此贴子已经被作者于2006-9-26 6:14:31编辑过]

改成这样试试

set rs=server.createobject("adodb.recordset")     
sql="SELECT top 100 NClassID,NClass,top FROM NClass order by top desc"
rs.Open sql,conn,1,1

Microsoft OLE DB Provider for ODBC Drivers
  错误 '80040e21'
 

ODBC 驱动程序不支持所需的属性。

加我QQ853305教下我好吗?

[此贴子已经被作者于2006-9-26 10:16:32编辑过]

不懂程序