{"id":48,"date":"2006-11-26T10:15:41","date_gmt":"2006-11-26T10:15:41","guid":{"rendered":""},"modified":"2006-11-26T10:15:41","modified_gmt":"2006-11-26T10:15:41","slug":"48","status":"publish","type":"post","link":"https:\/\/3v.org.cn\/?p=48","title":{"rendered":"\u65e5\u6587\u5bfc\u81f4Access\u641c\u7d22(80040e14\/\u5185\u5b58\u6ea2\u51fa)\u7684\u89e3\u51b3"},"content":{"rendered":"

==26\u4e2a\u65e5\u6587\u7247\u5047\u540d\u5bfc\u81f4Access\u641c\u7d22(80040e14\/\u5185\u5b58\u6ea2\u51fa)\u7684\u89e3\u51b3\u529e\u6cd5==<\/p>\n

\u30b4 \u30ac \u30ae \u30b0 \u30b2 \u30b6 \u30b8 \u30ba \u30c5 \u30c7 \u30c9 \u30dd \u30d9 \u30d7 \u30d3 \u30d1 \u30f4 \u30dc \u30da \u30d6 \u30d4 \u30d0 \u30c2 \u30c0 \u30be \u30bc
\u5f53\u5b57\u6bb5\u5185\u5305\u542b\u4e86\u8fd926\u4e2a\u65e5\u6587\u5b57\u7b26\u4efb\u610f\u4e00\u4e2a\u591a\u4e2a\u65f6,\u5c31\u4f1a\u5bfc\u81f4\u5728\u6267\u884cSQL\u8bed\u53e5\u4e2d\u5305\u542b\u4e86
[\u5b57\u6bb5] like ‘%aaaaa%’ \u6216 inStr(1,[\u5b57\u6bb5],’aaaaa’,1)>0
\u8fd9\u6837\u7684\u67e5\u8be2\u65f6,\u6beb\u65e0\u9053\u7406\u7684\u51fa\u73b0\u4e86
“Microsoft JET Database Engine \u9519\u8bef ‘80040e14’ \u5185\u5b58\u6ea2\u51fa”\u7684\u9519\u8bef
\u5176\u4ed6Jet SQL\u51fd\u6570\u547d\u4ee4\u672a\u4f5c\u6d4b\u8bd5\uff0c\u5927\u6982\u4e0e\u5b57\u7b26\u641c\u7d22\u5b9a\u4f4d\u5339\u914d\u76f8\u5173\u7684\u90fd\u53ef\u80fd\u51fa\u9519<\/p>\n

\u641c\u7d22\u76f8\u5173\u8d44\u6599\u5f97\u77e5\u88ab\u5fae\u8f6f\u5de5\u7a0b\u5e08\u8bc1\u5b9e\u662fAccess\u7684bug,\u53ef\u80fd\u662f\u8bed\u6cd5\u5173\u7cfb\u90fd\u662f\u5fae\u8f6f\u7684\u4e1c\u4e1c
\u5728vbs\u4e2d \u6267\u884cinStr(1,\u65e5\u6587\u5e73\u5047\u540d\u53d8\u91cf,”aaaaa”,1)\u4f9d\u7136\u8981\u51fa\u73b0\u9519\u8bef
Microsoft VBScript \u8fd0\u884c\u65f6\u9519\u8bef \u9519\u8bef ‘800a0005’ \u65e0\u6548\u7684\u8fc7\u7a0b\u8c03\u7528\u6216\u53c2\u6570: ‘instr’ <\/p>\n

\u6ca1\u6709\u641c\u7d22,\u56e0\u8fd9\u51e0\u4e2a\u5b57\u7b26\u51fa\u73b0Access\u7684\u8bba\u575b\u7f51\u7ad9\u641c\u7d22\u65e0\u6cd5\u8fdb\u884c,\u4f55\u7b49\u75db\u82e6
\u6628\u5929\u4e00\u670b\u53cb\u5927\u53eb\u602a\u4e8b,\u4ed6\u7684\u97f3\u4e50\u6570\u636e\u5e93\u65e0\u6cd5\u641c\u7d22\u4e86,\u53ea\u670930000\u6761\u8bb0\u5f55\u65f6\u662f\u597d\u7684
\u6beb\u65e0\u7591\u95ee,\u65e5\u6587\u7247\u5047\u540d\u662f\u7978\u6839,\u82b1\u51e0\u5206\u949f\u628a\u6709\u5305\u542b\u4e0a\u9762\u7684\u65e5\u6587\u66ff\u6362\u6210”?”\u641c\u7d22\u987a\u5229\u6062\u590d
\u627e\u6765\u8bba\u575b\u7a0b\u5e8f\u7528\u6237\u7fa4\u6700\u5927\u7684\u52a8\u7f51dvBBS AC\u7248\u672c 7.0SP2 \u7248\u6d4b\u8bd5,\u540c\u6837\u6709\u8fd9\u4e2a\u65e5\u6587\u53d1\u5e16\u540e \u5bfc\u81f4\u65e0\u6cd5\u641c\u7d22\u5e76\u4e14\u8fd0\u884c\u65f6\u51fa\u9519\u7684\u95ee\u9898
\u7ebf\u4e0a\u53bb\u641c\u7d22 ‘80040e14’ \u5185\u5b58\u6ea2\u51fa” \u7684\u9519\u8bef \u591a\u7684\u662f!<\/p>\n

\u4e00\u4e2a\u7b80\u5355\u7684\u65b9\u6cd5\u662f\uff1a
\u628a\u5982\u4e0b\u7684\u8bed\u53e5\uff1a
Sql = “select * From [tbname] Where Title like ‘%”&keyword&”%’ order By id Desc”
\u6362\u6210\uff1a
Sql = “select * from [tbname] where InStr(1,LCase(Title),LCase(‘”&keyword&”‘),0)<>0 order by id desc”<\/p>\n","protected":false},"excerpt":{"rendered":"

==26\u4e2a\u65e5\u6587\u7247\u5047\u540d\u5bfc\u81f4Access\u641c\u7d22(80040e14\/\u5185\u5b58\u6ea2\u51fa)\u7684\u89e3\u51b3\u529e\u6cd5== \u30b4 \u30ac \u30ae \u30b0 \u30b2 \u30b6 <\/p>\n

\n\t\t\t\t Read More <\/span> <\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[11],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-11"],"_links":{"self":[{"href":"https:\/\/3v.org.cn\/index.php?rest_route=\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/3v.org.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/3v.org.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/3v.org.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/3v.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=48"}],"version-history":[{"count":0,"href":"https:\/\/3v.org.cn\/index.php?rest_route=\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/3v.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/3v.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/3v.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}