OS : Microsoft Windows 2000 Server / Advanced Server
SQL : Microsoft SQL Server 2000 Standard / Enterprise Edition
서버: 메시지 16879, 수준 11, 상태 1, 프로시저 sp_makewebtask, 줄 125
SQL 웹 길잡이: 내부 오류입니다. 유니코드를 지정한 코드 페이지로 변환할 수 없습니다.
템플릿을 사용하여 지금 HTML파일을 생성시키고 있는데..
라는 메시지가 뜹니다.. HTML을 수도없이 확인했지만 정상입니다.
Html파일>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<head>
<style type="text/css">
<!--
.style3 {font-family: "굴림체"; font-size: 12px; }
.style5 {font-family: "굴림체"; font-size: 12px; font-weight: bold; }
-->
</style>
</head>
<body>
<h3 align="center">1. 물류현황</h3>
<table width="600" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#000000"
style="border-collapse:collapse">
<tr height="21">
<td width="145" height="49" rowspan="2" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span
class="style5">품목분류</span></td>
<td colspan="2" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">생산실적
</span></td>
<td colspan="3" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">영업실적
</span></td>
<td colspan="3" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">재고현황
</span></td>
</tr>
<tr height="28">
<td width="33" height="28" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">
일일</span></td>
<td width="39" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">누계
</span></td>
<td width="37" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">일일
</span></td>
<td width="40" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">누계
</span></td>
<td width="62" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">누계금액
<br>
(백만원)</span></td>
<td width="57" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">현재고
</span></td>
<td width="54" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">적정재고
</span></td>
<td width="59" align="center" bordercolor="#000000" bgcolor="#99CCFF"><span class="style5">적정대비
</span></td>
</tr>
<%begindetail%>
<tr height="18">
<td height="18" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
<td align="right" bordercolor="#000000"><span class="style3">
<%insert_data_here%>
</span></td>
</tr>
<%enddetail%>
</table>
2.이상발생현황<BR>
1)이상발생보고서
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td bgcolor="#99CCFF">제목</td>
<td bgcolor="#99CCFF">이상발생구분</td>
<td bgcolor="#99CCFF">발생일자</td>
<td bgcolor="#99CCFF">부서</td>
<td bgcolor="#99CCFF">이상발생번호</td>
</tr>
<%begindetail%>
<tr>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
</tr>
<%enddetail%>
</table>
사고보고서
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td bgcolor="#99CCFF">제목</td>
<td bgcolor="#99CCFF">사고발생구분</td>
<td bgcolor="#99CCFF">발생일자</td>
<td bgcolor="#99CCFF">부서</td>
<td bgcolor="#99CCFF">사고발생번호</td>
</tr>
<%begindetail%>
<tr>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
</tr>
<%enddetail%>
</table>
품질클레임
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td bgcolor="#99CCFF">제목</td>
<td bgcolor="#99CCFF">품목분류</td>
<td bgcolor="#99CCFF">증상</td>
<td bgcolor="#99CCFF">발생일자</td>
<td bgcolor="#99CCFF">발생비용</td>
<td bgcolor="#99CCFF">클레임번호</td>
</tr>
<%begindetail%>
<tr>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td align="right"><%insert_data_here%></td>
<td><%insert_data_here%></td>
</tr>
<%enddetail%>
</table>
반품현황
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td bgcolor="#99CCFF">상호</td>
<td bgcolor="#99CCFF">반품일자</td>
<td bgcolor="#99CCFF">품명</td>
<td bgcolor="#99CCFF">수량</td>
<td bgcolor="#99CCFF">반품번호</td>
</tr>
<%begindetail%>
<tr>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td align="right"><%insert_data_here%></td>
<td><%insert_data_here%></td>
</tr>
<%enddetail%>
</table>
일일AS정보
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td bgcolor="#99CCFF">제목</td>
<td bgcolor="#99CCFF">센터명</td>
<td bgcolor="#99CCFF">일자</td>
<td bgcolor="#99CCFF">AS번호</td>
</tr>
<%begindetail%>
<tr>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
<td><%insert_data_here%></td>
</tr>
<%enddetail%>
</table>
이상발생사항 진행현황
<table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">
<tr>
<td width="289" align="center" bgcolor="#99CCFF">구분</td>
<td width="224" align="center" bgcolor="#99CCFF">발생</td>
<td width="183" align="center" bgcolor="#99CCFF">진행</td>
<td width="194" align="center" bgcolor="#99CCFF">완결</td>
</tr>
<%begindetail%>
<tr>
<td>
<%insert_data_here%> </td>
<td align="right">
<%insert_data_here%> </td>
<td align="right">
<%insert_data_here%> </td>
<td align="right">
<%insert_data_here%> </td>
</tr>
<%enddetail%>
</table>
<img src="http://www.kdnaerp.com/images/navien_ci2.jpg" width="176" height="41">
</body>
</html>
SP호출부분>
exec sp_makewebtask
@outputfile = @cMakeHtm,
@query = 'Select * From ReportTempTbl01 Select * From ReportTempTbl03 Select * From
ReportTempTbl04 Select * From ReportTempTbl05 Select * From ReportTempTbl06 Select * From
ReportTempTbl07 Select * From ReportTempTbl02',
@templatefile = 'C:\EMail\Template\DailyLogisTemplate.tpl',
@whentype = 9, @charset='euc-kr'
|