|
|
|
|
 |
|
고미 / 2001-10-25 / 오후 2:05:05 / 210.183.218.144
조회수 : 139
|
| [질문] 일정관리에서 일자별로 출력하려하는데 |
다음과 같은 에러가 발생되는군요.ODBC는 문제가 없구,또한 월별로 출력하는 것은 이상없이 나오는데...
오류 형식:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 드라이버가 요청한 속성을 지원하지 않습니다.
/web/daily/calendar/daycontent.asp, line 11
*********************************************
<!--#include file="../dbopen.asp" -->
<%
year1=request("year1")
month1=request("month1")
day1=request("day1")
'no=request("no")
'sql="SELECT * FROM calendar where no="&no
sql = "SELECT * FROM calender where day1="&day1
'response.write sql
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,Conn,1
%>
<html>
<head>
<title><%=session("name")%>님의 일정관리 내용보기</title>
<meta name="generator" content="일정관리">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<div align="center">
<<table border cellpadding="0" cellspacing="0" width="90%"
bgcolor="#E3F1FF" bordercolor="white" bordercolorlight="black">
<tr>
<td width="10%" height="30" bgcolor="#D0D0D0">
<input type=hidden name="cp_type" value="input"> <p align="center"><span
style="font-size: 9pt"><font size="2" color="black">제 목</font></span></td>
<td valign="top" bgcolor="#EEEEEE"><p> <font size='2'><%=rs("title")%></td>
</tr>
<tr>
<td bgcolor="#D0D0D0"><p align="center"><span style="font-size: 9pt"><font
size="2" color="black">장 소</font></span></td>
<td bgcolor="#EEEEEE"><p> <font size='2'><%=rs("position")%></td>
</tr>
<tr>
<td height="30" bgcolor="#D0D0D0"><p align="center"><span style="font-size: 9pt"><font
size="2" color="black">일 자</font></span></td>
<td bgcolor="#EEEEEE"><p> <font size='2'><%=year1%>년 <%=month1%>월 <%=day1%>일</font></td>
</tr>
<tr>
<td height="35" bgcolor="#D0D0D0"><p align="center"><span style="font-size: 9pt"><font
size="2" color="black">시 간</font></span></td>
<td bgcolor="#EEEEEE"><p> <font size='2'><%=rs("s_time")%> <font color="red">→</font> <%=rs("e_time")%></td>
</tr>
<tr>
<td height="118" bgcolor="#D0D0D0"><p align="center"><span style="font-size: 9pt"><font
size="2" color="black">내 용</font></span></td>
<td height="118" bgcolor="#EEEEEE"><p><!-- 상세 일정 관리 내용 출력-->
<%
content = replace(rs("content"),chr(13) & chr(10),"<br>")
%><font size='2'><%=content%> </td>
</tr>
<tr>
<td height="40" colspan="2" bgcolor="#EFEFEF"> <input type="reset" value="돌아가기" onclick="javascript:history.back()"></td>
</tr>
</table></div></form>
</body>
</html> |
|
|
|