|
|
|
|
 |
|
얌전히살자 / 2003-02-09 / 오후 5:43:57 / 203.241.120.245
조회수 : 189
|
| [질문] 하나의 페이지에 2개의 레코드셋 열기 |
<!--#include file=../include/dbconn.inc-->
<%
s_select = request("s_select")
r_name = request("s_name")
s_index = request("s_index")
sqlstr = "select s_name, s_addr, s_peng, s_m_move, s_m_down, s_m_up, s_j_move, s_j_down, s_j_up, s_total,
s_room, s_st from sise_info where s_index = " & s_index
rs.open sqlstr, db
ls_name = rs(0)
ls_addr = rs(1)
ls_peng = rs(2)
ls_m_move = rs(3)
ls_m_down = rs(4)
ls_m_up = rs(5)
ls_j_move = rs(6)
ls_j_down = rs(7)
ls_j_up = rs(8)
ls_tatal = rs(9)
ls_room = rs(10)
ls_st = rs(11)
rs.close
sqlstr1 = "select r_name, r_addr, r_num, r_chng, r_dong, r_con, r_year, r_h_method, r_h_fuel, r_study,
r_subway, r_special, r_official, r_question from sise_apat where r_name = " & r_name
rs1.open sqlstr1, db
lr_name = rs1(0)
lr_addr = rs1(1)
lr_num = rs1(2)
lr_chng = rs1(3)
lr_dong = rs1(4)
lr_con = rs1(5)
lr_year = rs1(6)
lr_h_method = rs1(7)
lr_h_fuel = rs1(8)
lr_study = rs1(9)
lr_subway = rs1(10)
lr_special = rs1(11)
lr_official = rs1(12)
lr_question = rs1(13)
rs1.close
%>
<table border="1" width="100%" bordercolorlight="#5F5F5F" cellspacing="0" cellpadding="0"
bordercolordark="#FFFFFF">
<tr>
<td width="100%">
<table border="1" width="100%" bordercolorlight="#FFFFFF" cellspacing="0" cellpadding="3"
bordercolordark="#FFFFFF">
<tr>
<td width="100%" colspan="2" bgcolor="#E7E3E7">
<p align="center"><font color="#5A5D5A"><b>평
형 정 보</b></font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">평형</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A"><%=ls_peng%> 평</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">전용면적</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A"><%=ls_total%> 평</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">세대수</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A">[세대수]</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">매매가</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A">
<%=ls_m_down%> - <%=ls_m_up%> 만원
</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">전세가</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A">
<%=ls_j_down%> - <%=ls_j_up%> 만원</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">방수</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A"><%=ls_room%> 개</font></td>
</tr>
<tr>
<td width="19%" bgcolor="#EFEBEF"><font color="#5A5D5A">현관구조</font></td>
<td width="81%" bgcolor="#FFFBFF"><font color="#5A5D5A"><%=ls_st%></font></td>
</tr>
</table>
이게 원본 소스에요 그런데
rs1.open sqlstr1, db 이부분에서 자꾸
Microsoft JET Database Engine error '80040e10'
필요한 매개 변수 중 한 개 이상에 값이 주어지지 않았습니다.
/sise/sise_index_detail_1.asp, line 33
이런 에러 메세지가 뜨네요
님이 달아주신 답변글 제가 이해가 안되서리... 제가 초보라서요
|
|
|
|