{"author_name":"anocora","version":"1.0","provider_url":"https://hatena.blog","title":"\u8907\u6570\u30d5\u30a3\u30eb\u30bf\u8a2d\u5b9a","author_url":"https://blog.hatena.ne.jp/anocora/","categories":["Access \u696d\u52d9\u7ba1\u7406"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fanocora.hatenablog.com%2Fentry%2F2013%2F04%2F09%2F234338\" title=\"\u8907\u6570\u30d5\u30a3\u30eb\u30bf\u8a2d\u5b9a - \u3042\u306e\u3053\u3089\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u30db\u30fc\u30e0\u30baA\u3055\u3093\u304b\u3089\u3001\u30b3\u30e1\u30f3\u30c8\u3092\u9802\u3044\u305f\u306e\u3067\u3001\u79c1\u306e\u3084\u3063\u3066\u3044\u308b\u8907\u6570\u9805\u76ee\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u30db\u30fc\u30e0\u30baA\u3055\u3093\u306e\u3055\u308c\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u30d5\u30a3\u30eb\u30bf\u30fc\u51e6\u7406\u306e\u304a\u5f79\u306b\u7acb\u3064\u304b\u306f\u5224\u308a\u307e\u305b\u3093\u304c\uff1f \u3053\u3093\u306a\u691c\u7d22\u9805\u76ee\u3092\u8a2d\u5b9a\u3057\u3001\u691c\u7d22\u9805\u76ee\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u304b\u5224\u5b9a\u3057\u306a\u304c\u3089\u3001SQL\u6587\u3092\u7e4b\u3044\u3067\u3044\u304d\u3001\u51fa\u6765\u3042\u304c\u3063\u305fSQL\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059\u3002 \u201dAND\u201d\u3067\u7e4b\u3044\u3067\u3044\u304f\u306e\u3067\u3001\u6700\u521d\u306e\"1=1\"\u304c\u809d\u3067\u3059\u3002 \u3010SQL\u6587\u3011\u2190\u3010VBA\u8a18\u8ff0\u3011\u306b\u5909\u66f4\u3057\u307e\u3059\u3002\uff0813.04.11\uff09 StrSQL = \"1 = 1\" If IsNull(Me.txt_\u4ef6\u540d) = False Then StrSQL = StrSQL & \" AND \u4ef6\u540d like '*\u2026","url":"https://anocora.hatenablog.com/entry/2013/04/09/234338","type":"rich","width":"100%","height":"190","blog_title":"\u3042\u306e\u3053\u3089\u306e\u30d6\u30ed\u30b0","blog_url":"https://anocora.hatenablog.com/","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/anocora/20260610/20260610221047.jpg","published":"2013-04-09 23:43:38","provider_name":"Hatena Blog"}