标题:Microsoft JET Database Engine 错误 '80040e10' 至少一个参数没有被指定值 ...
只看楼主
qq792587976
Rank: 1
等 级:新手上路
帖 子:10
专家分:7
注 册:2010-6-1
结帖率:33.33%
 问题点数:0 回复次数:4 
Microsoft JET Database Engine 错误 '80040e10' 至少一个参数没有被指定值。
网址:http://www.,26,2
打开显示以下错误,请大侠指点下是什么原因,谢谢了。

Microsoft JET Database Engine 错误 '80040e10'

至少一个参数没有被指定值。

/inc/function.asp,行 1319


附function.asp的一段代码:红色的为1319行。

Function f_typeinfo(C1,C2,C3,T1,T2,T3,TitleZs,PW1,PH1,TitleZs1,TextZs1,PW2,PH2,TitleZs2,LW)
    If T1=0 Then Exit Function
    Dim TypeData,Page,Maxperpage,ShowType,OrderType,PageType,ss
    Dim C,T,Sql,Rs,DataCount,PageCount,i
    If C3>0 then
        C=" And City_Oneid="&C1&" And City_Twoid="&C2&" And City_Threeid="&C3
    ElseIf C2>0 Then
        C=" And City_Oneid="&C1&" And City_Twoid="&C2
    ElseIf C1>0 Then
        C=" And City_Oneid="&C1
    End If
   
    IF T3>0 Then
        T=" And Type_Oneid="&T1&" And Type_Twoid="&T2&" And Type_Threeid="&T3
    ElseIf t2>0 Then
        T=" And Type_Oneid="&T1&" And Type_Twoid="&T2
    Else
        T=" And Type_Oneid="&T1
    End If
    Page = StrInt(Request.QueryString("Page"))
    If Page<1 Then Page = 1
    ShowType = StrInt(Request.QueryString("ShowType"))
    OrderType = StrInt(Request.QueryString("OrderType"))
    PageType = StrInt(Request.QueryString("PageType"))
    If PageType=1 Then
        Maxperpage = 40
    ElseIF PageType=2 Then
        Maxperpage = 80
    Else
        Maxperpage = 20
    End If
    Page=Strint(Request.QueryString("Page"))
    If Page<1 Then Page=1
    If Maxperpage<1 Then Maxperpage=20
    If Application(CacheName&"_Setup")(0)<>"" Then
        Sql = "Select top "&Page*Maxperpage&" adid,City_oneid,City_twoid,City_threeid,City_one,City_two,City_three,type_oneid,type_twoid,type_threeid,[color],[title],[text],[date],pic,hits,[Money],MoneyDate,[Top],[hot] From China_Data Where mark='yes' And (DateDiff(d,now(),[stop])>=1 Or (DateDiff(d,now(),[MoneyDate])>=1 And [Money]>0)) "&c&t&" order by [top] desc"
    Else
        Sql = "Select top "&Page*Maxperpage&" adid,city_oneid,city_twoid,city_threeid,city_one,city_two,city_three,type_oneid,type_twoid,type_threeid,[color],[title],[text],[date],pic,hits,[Money],MoneyDate,[Top],[hot] From China_Data Where mark='yes' And ([stop]>=Date() Or ([Money]>0 And MoneyDate>=date())) "&c&t&" order by [top] desc"
    End If
   
    Select Case OrderType
        Case 1
            Sql = Sql & ",Adid"
        Case 2
            Sql = Sql & ",Adid Desc"
        Case 3
            Sql = Sql & ",hits"
        Case 4
            Sql = Sql & ",hits Desc"
        Case Else
            Sql = Sql & ",[money] Desc,Adid Desc"
    End Select
    If Not IsObject(Conn) Or Conn Is NoThing Then DbLink
    Set Rs=server.createobject("adodb.recordset")
    Rs.Open Sql,Conn,1,1   
    If Not Rs.Eof Then Rs.Move (Maxperpage*(page-1))
    IF Not Rs.Eof Then typeData=Rs.Getrows
   
    IF IsArray(TypeData) Then
        For i=0 To Ubound(TypeData,2)
            If ShowType=2 Then
                    Response.Write "<div style=""width:"&LW&"px;float:left;overflow:hidden;"" align=""center""><a href="&S_path("",TypeData(0,i),"")&" target=""_blank"">"
                    If TypeData(14,i)<>"||||" And not isnull(TypeData(14,i)) Then
                        Response.Write "<img src=""adpic/"&ShowPic(TypeData(14,i))&""" width="&PW2&" height="&PH2&" style=""margin:5px 0 8px 0; "">"
                    Else
                        Response.Write "<img src=""images/nopoto_1.gif"" width="&PW2&" height="&PH2&" style=""margin:5px 0 8px 0; "">"
                    End If
                    Response.Write "</a><br><a href="&S_path("",TypeData(0,i),"")&" target=""_blank"">"&CutStr(TypeData(12,i),TitleZs2)&"</a></div>"
            Else
                Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr>"
                If ShowType<>1 Then
                    If TypeData(14,i)<>"||||" And Not IsNull(TypeData(14,i)) Then
                        Response.Write "<td width="&PW1&"><img src=""adpic/"&ShowPic(TypeData(14,i))&""" width="&PW1&" height="&PH1&" style=""margin:5px 0 5px 0; ""></td>"
                    Else
                        Response.Write "<td width=""80"" style=""border-bottom:1px #CCCCCC dashed""><img src=""images/nopoto.gif"" width="&PW1&" height="&PH1&" style=""margin:5px 0 5px 0; ""></td>"
                    End If
                End If
                Response.Write "<td width=100  height=28  style=""border-bottom:1px #CCCCCC dashed"">【"
                IF TypeData(6,i)<>"" And Not IsNull(TypeData(6,i)) Then
                    Response.Write "<a href=Type.asp?C="&TypeData(1,i)&","&TypeData(2,i)&","&TypeData(3,i)&"&T="&t1&","&t2&","&t3&">"&TypeData(6,i)&"</a>"
                ElseIF TypeData(5,i)<>"" And Not IsNull(TypeData(5,i)) Then
                    Response.Write "<a href=Type.asp?C="&TypeData(1,i)&","&TypeData(2,i)&"&T="&t1&","&t2&","&t3&">"&TypeData(5,i)&"</a>"
                ElseIF TypeData(4,i)<>"" And Not IsNull(TypeData(4,i)) Then
                    Response.Write "<a href=Type.asp?C="&TypeData(1,i)&"&T="&t1&","&t2&","&t3&">"&TypeData(4,i)&"</a>"
                End IF
                Response.Write "】</td><td  style=""border-bottom:1px #CCCCCC dashed""><font color="""&TypeData(10,i)&"""><a href="&S_path("",TypeData(0,i),"")&" target=""_blank"">"&TypeData(11,i)&"</a></font>"
                If TypeData(14,i)<>"||||" And Not IsNull(TypeData(14,i)) Then Response.Write " <img src=""Images/www9/picflag.gif"" width=""13"" height=""13"" alt=""附图"">"
                If ShowType<>1 Then Response.Write "<br><a href="&S_path("",TypeData(0,i),"")&" target=""_blank"">"&CutStr(TypeData(12,i),TextZs1)&"</a>"
                Response.Write "</td><td width=50px style=""border-bottom:1px #CCCCCC dashed"">&nbsp;"
                If TypeData(16,i)>0 And TypeData(17,i)>=Date() Then Response.Write " <img src=""Images/www9/top_45.gif"" width=""15"" height=""13"" alt=""竟价""> "
                If Cbool(TypeData(18,i)) Then Response.Write " <img src=""Images/www9/top_46.gif"" width=""15"" height=""13"" alt=""固顶""> "
                If Cbool(TypeData(19,i)) Then Response.Write " <img src=""Images/www9/top_44.gif"" width=""15"" height=""13"" alt=""热点""> "
                Response.Write "</td><td width=100  style=""border-bottom:1px #CCCCCC dashed"">"&TypeData(13,i)&"</td></tr></table>"
            End If
        Next
        Response.Write "<div style=""clear:both"" align=center>"&PageSplit(MaxperPage,DataCount,Page,PageCount,"type.asp","&C="&c1&","&c2&","&c3&"&T="&t1&","&t2&","&t3&"&ShowType="&ShowType&"&OrderType="&OrderType&"&PageType="&PageType&"")&"</div>"
    Else
        Response.Write "<div align=center>暂无本类信息</div>"
    End IF
End Function
搜索更多相关主题的帖子: Microsoft Engine Database JET 参数 
2010-09-13 10:38
hams
Rank: 12Rank: 12Rank: 12
等 级:贵宾
威 望:18
帖 子:912
专家分:3670
注 册:2008-7-30
得分:0 
把那行换成:
Response.Write  Sql

看看是什么结果再找出错原因

俺不高手,俺也是来学习的。
俺的意见不一定就对,当你不认同时请点忽视按钮。
当走到十字路口不知该如何走时,可在论坛问下路,但你若希望别人能一路把你送到目的地,显然是不现实的,因为别人也有自己要走的路。
2010-09-13 15:09
魏兴耀
Rank: 8Rank: 8
来 自:江西
等 级:蝙蝠侠
威 望:3
帖 子:246
专家分:840
注 册:2009-11-9
得分:0 
把相关的值弹出来看看是不是自己想要的

只有大胆尝试,才有机会得到想要的成功
2010-09-13 17:25
qq792587976
Rank: 1
等 级:新手上路
帖 子:10
专家分:7
注 册:2010-6-1
得分:0 
Select top 20 adid,city_oneid,city_twoid,city_threeid,city_one,city_two,city_three,type_oneid,type_twoid,type_threeid,[color],[title],[text],[date],pic,hits,[Money],MoneyDate,[Top],[hot] From China_Data Where mark='yes' And ([stop]>=Date() Or ([Money]>0 And MoneyDate>=date())) And Type_Oneid=4 order by [top] desc,[money] Desc,Adid Desc


加了response.write Sql后显示这个sql语句
2010-09-13 22:05
hams
Rank: 12Rank: 12Rank: 12
等 级:贵宾
威 望:18
帖 子:912
专家分:3670
注 册:2008-7-30
得分:0 
真复杂,看得头晕
方括号的用法不了解

俺不高手,俺也是来学习的。
俺的意见不一定就对,当你不认同时请点忽视按钮。
当走到十字路口不知该如何走时,可在论坛问下路,但你若希望别人能一路把你送到目的地,显然是不现实的,因为别人也有自己要走的路。
2010-09-14 09:11



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-320275-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 1.076636 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved