Microsoft JET Database Engine 错误 '80040e10'
至少一个参数没有被指定值。
/system/CindexHTML.asp,行 433
见下面:
dim sql,menu,rs,newWin,dMenu,dDate,nimg,title,fd,fdsn
menu=""
fd=DispFormat(tab)
menuid=FindAllSub(MenuID)
if instr(menuid,",")>0 then menuid=left(menuid,len(menuid)-1)
menu=" where Menuid in ("&menuid&") "
Select case iType
case 1
menu=replace(menu,"where","and")
SQL="Select top "&tSN&" "&fd(0,6)&"id,menuid,SaveDate from ["&tab&"] where Auditing=1 "&menu&" order by id desc"
case 2
SQL="Select top "&tSN&" "&fd(0,6)&"id,menuid,SaveDate from (Select top 100 * from ["&tab&"] where Auditing=1 order by id desc)DERIVEDTBL "&menu&" order by Click desc"
case 3
SQL="Select top "&tSN&" "&fd(0,6)&"id,menuid,SaveDate from (Select top 100 * from ["&tab&"] where Auditing=1 order by id desc)DERIVEDTBL "&menu&" order by renum desc"
End Select
Set rs=Server.CreateObject("ADODB.RecordSet")
'Response.Write sql&"<br>"
rs.Open sql,conn,1,1 错误行
求求各位大虾解救,不胜感激!!!