|
|
|
|
 |
|
浩然之氣 / 2003-02-10 / 오전 11:05:14 / 203.255.3.190
조회수 : 192
|
| [질문] 하나의 페이지에 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
> 이런 에러 메세지가 뜨네요
> 님이 달아주신 답변글 제가 이해가 안되서리... 제가 초보라서요
>
-----------------------------------------------------------
혹시 rs1 객체를 새성하지 않으신것 아닌가요?
아니면 sql 문장이 틀린 것 같은데요....
r_name이란 변수에 들어 있는 값이 혹시 문자형이 아닌가요?
문자형이라면 where 절에서 작은 따옴표로 묶어줘야 겠지요...
그럼...
|
|
|
|