꿈속나라

당신에게로 떠나는 꿈속여행 - 꿈속나라(http://www.inyourdream.net)

입국하기 | 영주권 신청

몸부림 골라골라

착각한아이

숫자맞추기

흔적남기기

친구집 놀러가기

모두드림님의 홈

在祐님의 홈

현우님의 홈

별아해님의 홈

햇살님의 홈

이나니님의 홈

유리알님의 홈

냠냠이님의 홈

꼭지님의 홈

대성님의 홈

수정하실때는 필수항목을 모두 입력하셔야 합니다.

이름 *	공지사항 비공개 HTML 사용
제목 *
내용 *	저번에 한 번 질문드렸던건데, 레코드 필드들을 끌어오는 부분입니다.end if가 없다는 에러 였죠. 이번에 조금 바꾸어 봤는데, 안되네요. 에러 메세지는 Microsoft VBScript 컴파일 오류 error '800a03ea' 구문 오류 /finaltest/Adclick/win_ratio/test1.asp, line 44 >elseif !=isNull(rs2(0)) then ratio=rs2(0).Fields("ratio") ^ > <% set db=server.CreateObject("ADODB.connection") db.Open ("dsn=xx;uid=xx;pwd=xx;) SQL2 = "SELECT * from ratio_ratio " SQL2 = SQL2&" where league_num="& Request.QueryString("league_num") SQL2 = SQL2&" AND item_num="& request("item_num") Set Rs2 = Server.CreateObject("ADODB.Recordset") Rs2.Open SQL2,db,1,2 %> <body bgcolor="#ffffff" link="#000080" vlink="#000080" alink="#000080"> <form name="myform" method="post" action="win_ratio_ok.asp"> <!--베팅참가인원이 없을 경우--> <br><br> <center><img src="img/league_ratio.gif" WIDTH="303" HEIGHT="37"></center> <p align="center"> <table border="1" cellspacing="0" cellpadding="0" width="640" style="HEIGHT: 201px; WIDTH: 404px"> <tbody> <tr> <td colspan="4" height="15" border="1" bgcolor="#cee7ff" valign="center"><p align="center"><font face="돋움" size="2" color="#002200"><b> 1 위 팀 예 상 승 률 </b></font></p></td> </tr> <tr> <td width="10%" height="5" align="middle"><input type="radio" name="ratio_index_num" value="1"></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.7%미만 </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%if isnull(rs2(0)) then ratio=0%><%=ratio%><%elseif !=isNull(rs2(0)) then ratio=rs2(0).Fields("ratio") %><%=ratio%></td> <td width="10%" height="5" align="middle"><input type="radio" name="ratio_index_num" value="2"></font></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.7% ~ 0.75% </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(1)) then ratio=0%><%=ratio%><%elseif <>isnull(rs2(1)) then ratio=rs2(1).Fields("ratio") f%><%=ratio%></td> </tr> <tr> <td width="10%" height="10" align="middle"><input type="radio" name="ratio_index_num" value="3"></td> <td width="40%" height="10" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.75% ~ 0.8% </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(2)) then ratio=0%><%=ratio%><%elseif <>isnull(rs2(2)) then ratio=rs2(2).Fields("ratio") %><%=ratio%></td> <td width="10%" height="10" align="middle"><input type="radio" name="ratio_index_num" value="4"></td> <td width="40%" height="10" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.8% ~ 0.85% </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(3)) then ratio=0%><%=ratio%><%elseif <>isnull(rs2(3)) then ratio=rs2(3).Fields("ratio") %><%=ratio%></td> </tr> <tr> <td width="10%" height="10" align="middle"><input type="radio" name="ratio_index_num" value="5"></td> <td width="40%" height="10" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.85% ~ 0.9% </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(4)) then ratio=0%><%=ratio%><%elseif <> isnull(rs2(4)) then ratio=rs2(4).Fields("ratio")f%><%=ratio%></td> <td width="10%" height="10" align="middle"><input type="radio" name="ratio_index_num" value="6"></td> <td width="40%" height="10" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.9% ~ 0.95% </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(5)) then ratio=0%><%=ratio%><%elseif <>isnull(rs2(5)) then ratio=rs2(5).Fields("ratio") %><%=ratio%></td> </tr> <tr> <td width="10%" height="10" align="middle"><input type="radio" name="ratio_index_num" value="7"></td> <td width="40%" height="10" border="1" bgcolor="white" valign="center"><p align="center"><font face="돋움" size="2" color="blue"> 0.95%이상 </font></p></td> <td width="40%" height="5" align="middle" border="1" bgcolor="white" valign="center"><p align="center"></p><%elseif isnull(rs2(6)) then ratio=0%><%=ratio%><%elseif <>isnull(rs2(6)) then ratio=rs2(6).Fields("ratio") end if%><%=ratio%></td> <td width="50%" colspan="2" height="10" align="middle"> <font face="돋움" size="2">총 참여인원 : <%=total_person%> 명<br> 총 합계금액 : <%=total_point%> point</font> </td> </tr> <p></p></td></tr></tbody></table></p> <center> <table border="0"> <tr> <td><input type="hidden" name="item_num" value="<%=item_num%>" checked> </td> </tr> <tr> <td><input type="hidden" name="league_num" value="<%=league_num%>" checked> </td> </tr> </table> </form> <% Rs.Close db.Close Set Rs = Nothing Set db = Nothing %> </html>

추가할 이미지를 입력하세요.

이미지 1
이미지설명 1

추가할 자료를 입력하세요.

자료 1
자료설명 1

추가할 싸이트를 입력하세요.

관련싸이트 1
싸이트설명 1

Password *