소스는 아래와 같고여,,db까지 연결이되는데...동을 입력하게되면 모든 db가 나오는데 왜그러져.........조언부탁합니다.
<--!
<%
if Request("chk")="submit" then
Set dbcon = Server.CreateObject("ADODB.Connection")
Dbcon.Open ("newzip")
SQL = "SELECT * FROM Zipcode WHERE DongRi like '%" & Request("dongri") & "%'"
set RS = dbcon.execute("select * from zipcode")
if Rs.EOF then
%>
<script>
alert("찾으시는 <%= Request("DongRi")%>는 없는 주소입니다.");
</script>
<%
end if
end if
%>
<html>
<head>
<title>두원시스템-우편번호검색(국내)</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<meta name="Description" content="Daum-우편번호(국내)">
<meta name="Keywords" content="Daum-우편번호(국내)">
</head>
<script language="JavaScript">
<!--
function check(){
if(document.zipcode.dongri.value =="")
alert("동 이름을 입력하세요.");
else
document.zipcode.submit();
}
function replacezip(zipcode, address){
opener.docment.member.memberzipcode.value = zipcode;
opener.docment.member.memberaddress.value = address;
opener.docment.member.memberaddress.focus();
self.close();
}
//-->
</script>
<body bgcolor = #ffffff marginwidth=0 marginheight=0 topmargin=0 leftmargin=0>
<form name="zipcode" method="post" action="./zipsearch.asp">
<table border="0" cellpadding="2" width="450" align="center">
<tr>
<td bgcolor="fece00" width="17" nowrap><img src="http://image.hanmail.net/hanmail/s_img/news/trans.gif " width=17 height=1></td>
<td bgcolor="black" width="433" valign="bottom"><font size="2"> . <font color="white">국내 우편번호찾기</font></font></td>
</tr>
<tr>
<td colspan="2">
<br>
<img src="http://image.hanmail.net/hanmail/s_img/news/trans.gif " width=17 hetght=1>
<font size ="2">거주하는 지역의 '동이름'을 입력해 주십시요.<br>
<img src="http://image.hanmail.net/hanmail/s_img/news.gif " width=17 height=1>
예 : 서울시 강남구 삼성1동이라면 '삼성1'만 입력하시면 됩니다.
<br><br>
<img src="http://image.hanmail.net/hanmail/s_img/news/trans.gif " width=17 height=1>
이름입력</font><input type="text" name="dongri"><font size="2">동(읍/면/리)
<input type="Button" name="find" value="찾기" onclick="check();"></font>
<input type="hidden" name="chk" value="submit">
</tr>
</table>
</form>
<table align="center" width="400">
<tr>
<td>
<%
if Request("chk")="submit" then
do until Rs.EOF
%>
<li><a href="javascript:replacezip('<%=Rs("zipcode")%>','<%=Rs("SiDo") %>
<%=Rs("GuGun")%> <%=Rs("DongRi")%> ')">
<font size="2"><%=Rs("zipcode") %> <%=Rs("sido") %> <%=Rs("GuGun")
%> <%=Rs("DongRi") %> <%=Rs("BunJi")%></font></a>
<%
RS.MoveNext
loop
end if
%></td>
</tr>
</table>
</body>
</html>
-->
카페 게시글
ASP Q/A
[질문]
우편번호검색에 관한 질문...
최현수
추천 0
조회 32
01.06.25 10:46
댓글 0
북마크
번역하기
공유하기
기능 더보기
다음검색