<%
'**********************************************************************************************************************
'▶ 변수 항목
' G_TOTAL_RECORD : 전체 레코드 수
' G_PAGE : 현재 페이지 수
' G_TOTAL_PAGE : 전체 페이지 수
'**********************************************************************************************************************
'**********************************************************************************************************************
'▶ 리스트 출력수 & 현재 페이지
'**********************************************************************************************************************
G_PAGE_SIZE = 10
cPage = SQLTEXT(REQUEST("cPage"), 1)
'**********************************************************************************************************************
'▶ Search WHERE 내용 (내용 검색)
'**********************************************************************************************************************
rqWhere = TRIM(REQUEST("strWhere")) '// 검색 항목
rqQuery = TRIM(REQUEST("strQuery")) '// 검색 내용
strWhere = "&strWhere=" & rqWhere
strQuery = "&strQuery=" & rqQuery
IF NotNull(rqWhere) AND NotNull(rqQuery) THEN
SEARCH = " AND ("& SQLTEXT(rqWhere, 1) &" LIKE '%"& SQLTEXT(rqQuery, 1) &"%')"
END IF
'**********************************************************************************************************************
'▶ ORDER 조건 (내용 정렬)
'**********************************************************************************************************************
rqSort = TRIM(REQUEST("strSort")) '// 정렬 방법 (DESC OR ASC)
rqSortItem = TRIM(REQUEST("strSortItem")) '// 정렬 항목
strSort = "&strSort=" & rqSort
strSortItem = "&strSortItem=" & rqSortItem
IF NotNull(rqSort) AND NotNull(rqSortItem) THEN
ORDER = " ORDER BY "& SQLTEXT(rqSortItem, 1) &" "& SQLTEXT(rqSort, 1)
ELSE
ORDER = " ORDER BY NOT_WDATE DESC"
END IF
'**********************************************************************************************************************
'▶ 기본 WHERE 조건
'**********************************************************************************************************************
WHERE = " WHERE (NOT_STATE = '1') "
'**********************************************************************************************************************
'▶ SQL 구문 및 실행
'**********************************************************************************************************************
SQL = "SELECT * FROM HMASP_"& FACTOR &"_NOTICE_BOARD "& WHERE & SEARCH & ORDER
SET pRS = exPAGE(FACTOR, SQL, cPage)
%>
 |
HOME > 게시판 > 공지사항 |
|
|
|
|
|
| |
 |
| |
|
|
|
 |
<%
IF pRS.EOF OR pRS.BOF THEN
echo " " & vbCrLf
echo " | 등록된 내용이 없습니다. | " & vbCrLf
echo " | " & vbCrLf
echo " " & vbCrLf
END IF
DO WHILE NOT pRS.EOF
NOT_TITLE = pRS("NOT_TITLE")
NOT_NAME = pRS("NOT_NAME")
NOT_FILE = pRS("NOT_FILE")
NOT_READ = pRS("NOT_READ")
NOT_CONTENT = pRS("NOT_CONTENT")
NOT_WDATE = pRS("NOT_WDATE")
%>
| <%=G_TEMP_LIST_NUM%> |
|
<%=NOT_NAME%> |
<%=VDATE(NOT_WDATE, 2)%> |
<%=NOT_READ%> |
|
|
<%
'**********************************************************************************************************************
G_TEMP_LIST_NUM = G_TEMP_LIST_NUM - 1
pRS.MOVENEXT
LOOP
pRS.CLOSE
SET pRS = NOTHING
'**********************************************************************************************************************
%>
|
|
|
<%=ShowPageBar(cPage,"../../IMAGES/school/prev_btn.gif","../../IMAGES/school/next_btn.gif", strParam)%>
|
|
| |
|
|
