{"id":785,"date":"2020-06-16T13:44:53","date_gmt":"2020-06-16T04:44:53","guid":{"rendered":"https:\/\/csharp.ihavenomoney.co.kr\/?p=785"},"modified":"2020-06-16T13:45:40","modified_gmt":"2020-06-16T04:45:40","slug":"asp-%eb%94%94%eb%b9%84-%ec%a0%91%ec%86%8d%ed%95%98%ec%97%ac-rs-%eb%a0%88%ec%bd%94%eb%93%9c-%ea%b0%80%ec%a0%b8%ec%98%a4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/csharp.ihavenomoney.co.kr\/?p=785","title":{"rendered":"asp \ub514\ube44 \uc811\uc18d\ud558\uc5ec Rs \ub808\ucf54\ub4dc \uac00\uc838\uc624\uae30"},"content":{"rendered":"\n<pre class=\"lang:asp decode:true \" >&lt;!--#include file=\"..\/dbconn.asp\"--&gt;\r\n\r\n&lt;%\r\ncall dbconn_sub '\ub514\ube44\uc5f0\uacb0'\r\n\r\n   strSQL = \"Select top 1 id, mail from board where idx = '\"&amp;id&amp;\"' and mail ='\" &amp; email &amp; \"'\"\r\n   SET Rs=db.Execute(strSQL)\r\n   \r\n   if (Rs.BOF or Rs.EOF) then\r\n      response.write \"\ub370\uc774\ud0c0\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.\"\r\n   else\r\n      response.write Rs(\"id\")\r\n      response.write Rs(\"mail\")\r\n      Rs.close : set Rs = nothing\r\n   end if\r\n'\/\/\/ DB\uc811\uc18d\ub04a\uae30\r\ndb.close : set db=nothing\r\n%&gt;\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&lt;!&#8211;#include file=&#8221;..\/dbconn.asp&#8221;&#8211;&gt; &lt;% call dbconn_sub &#8216;\ub514\ube44\uc5f0\uacb0&#8217; strSQL = &#8220;Select top 1 id, mail from board where idx = &#8216;&#8221;&amp;id&amp;&#8221;&#8216; and mail ='&#8221; &amp; email &amp; &#8220;&#8216;&#8221; SET Rs=db.Execute(strSQL) if (Rs.BOF or Rs.EOF) then response.write &#8220;\ub370\uc774\ud0c0\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.&#8221; else response.write Rs(&#8220;id&#8221;) response.write Rs(&#8220;mail&#8221;) Rs.close : set Rs = nothing end if &#8216;\/\/\/ DB\uc811\uc18d\ub04a\uae30 db.close : set db=nothing\u2026 <span class=\"read-more\"><a href=\"https:\/\/csharp.ihavenomoney.co.kr\/?p=785\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[],"class_list":["post-785","post","type-post","status-publish","format-standard","hentry","category-asp"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=785"}],"version-history":[{"count":2,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/785\/revisions"}],"predecessor-version":[{"id":787,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/785\/revisions\/787"}],"wp:attachment":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}