Microsoft JET Database Engine 错误 '80004005' 所有记录中均未找到搜索关键字。 - 编程论坛

#2

huade2008-04-30 17:21

#3

lili06109312008-04-30 17:24

代码有错误.你再好好看一下,哪里不对

#4

huade2008-04-30 17:25

数据库的索引是用（有重复）

#5

huade2008-04-30 17:30

/myweb/admin/pinglun/up_pinglun.asp，行 40

<%
If (CStr(Request("MM_update")) = "form1") Then
  If (Not MM_abortEdit) Then
    ' execute the update
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject (")
    MM_editCmd.ActiveConnection = MM_connms_STRING
    MM_ = "UPDATE MS_productspdf SET mctl_id = ?, ctl_id = ?, cp_id = ?, p_name = ?, p_nameeng = ? WHERE pdf_id = ?"
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 5, 1, -1, MM_IIF(Request.Form("s1"), Request.Form("s1"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 5, 1, -1, MM_IIF(Request.Form("s2"), Request.Form("s2"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 5, 1, -1, MM_IIF(Request.Form("s3"), Request.Form("s3"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 203, 1, 536870910, Request.Form("download")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 203, 1, 536870910, Request.Form("downloaden")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 5, 1, -1, MM_IIF(Request.Form("MM_recordId"), Request.Form("MM_recordId"), null)) ' adDouble
    MM_editCmd.Execute     '这里是40行
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "in_zpdf.asp"
    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>

#6

yms1232008-04-30 17:41

这个是使用Dreamweaver MX自动生成的代码？

#7

huade2008-04-30 17:52

回复 6# 的帖子

是使用Dreamweaver MX自动生成的代码

#8

huade2008-05-01 20:19

有没有人曾经遇到过这种情况呀，帮帮忙呀~~~

#9

makebest2008-05-01 21:00

我猜一下，建表的时候没有做主键吧

#10

huade2008-05-03 12:32

回复 9# 的帖子

有主键的呀~~~~问题至今仍没解决，有请高手指点！！

#11

lele20072008-05-03 13:31

DW生成的太难看了！还是自己编写的要好些！容易维护！

#12

huade2008-05-04 09:41

不会吧，有谁知道能解决这样的问题吗？

#13

huade2008-05-07 16:37

只能用数据库的修复和压缩功能来修复这个数据库

但是这种方法不是根治这个故障的主要方法。只要你第二次还有提交一个大块数据给这个备注型字段，这个故障又出来啦！！

#14

hmhz2008-05-07 18:10

DW做的不给回答，我从来不回答DW产生的问题