asp 디비 접속하여 Rs 레코드 가져오기


<!--#include file="../dbconn.asp"-->

<%
call dbconn_sub '디비연결'

   strSQL = "Select top 1 id, mail from board where idx = '"&id&"' and mail ='" & email & "'"
   SET Rs=db.Execute(strSQL)
   
   if (Rs.BOF or Rs.EOF) then
      response.write "데이타가 없습니다."
   else
      response.write Rs("id")
      response.write Rs("mail")
      Rs.close : set Rs = nothing
   end if
'/// DB접속끊기
db.close : set db=nothing
%>

call dbconn_sub '디비연결'

strSQL = "Select top 1 id, mail from board where idx = '"&id&"' and mail ='" & email & "'"

SET Rs=db.Execute(strSQL)

if (Rs.BOF or Rs.EOF) then

response.write "데이타가 없습니다."

else

response.write Rs("id")

response.write Rs("mail")

Rs.close : set Rs = nothing

end if

'/// DB접속끊기

db.close : set db=nothing