ClassicASP 신청서 상세보기 샘플
페이지 정보
본문
<%
Option Explicit
set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB.1;Password=비밀번호;Persist Security Info=True; User ID=아이디; Initial Catalog=디비이름; Data Source=디비주소"
sql = "select * from application where num = '"& request("num") &"' "
set rs = Server.CreateObject("ADODB.Recordset")
'response.write SQL
rs.open sql,db,1
if not rs.EOF or not rs.BOF then ' 자료가 있을때
name = rs("name")
email = rs("email")
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<title>후원자 신청하기</title>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="110" height="30" align="center" bgcolor="#f7f7f7">성 명</td>
<td style="padding:0 10px 0 10px;"><%=name%></td>
</tr>
<tr>
<td width="110" height="1" bgcolor="#dadada"><img src="../images/spacer.gif" alt="" /></td>
<td bgcolor="#dadada"><img src="../images/spacer.gif"alt="" /></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#f7f7f7">E-mail</td>
<td class="text" style="padding:0 10px 0 10px;"><%=email%></td>
</tr>
</table>
</body>
</html>
Option Explicit
set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB.1;Password=비밀번호;Persist Security Info=True; User ID=아이디; Initial Catalog=디비이름; Data Source=디비주소"
sql = "select * from application where num = '"& request("num") &"' "
set rs = Server.CreateObject("ADODB.Recordset")
'response.write SQL
rs.open sql,db,1
if not rs.EOF or not rs.BOF then ' 자료가 있을때
name = rs("name")
email = rs("email")
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<title>후원자 신청하기</title>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="110" height="30" align="center" bgcolor="#f7f7f7">성 명</td>
<td style="padding:0 10px 0 10px;"><%=name%></td>
</tr>
<tr>
<td width="110" height="1" bgcolor="#dadada"><img src="../images/spacer.gif" alt="" /></td>
<td bgcolor="#dadada"><img src="../images/spacer.gif"alt="" /></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#f7f7f7">E-mail</td>
<td class="text" style="padding:0 10px 0 10px;"><%=email%></td>
</tr>
</table>
</body>
</html>
댓글목록
등록된 댓글이 없습니다.