|
<%
' ini untuk pengumuman
Set Rs3 = Server.CreateObject("ADODB.RECORDSET")
Rs3.ActiveConnection = MM_connect_String
'Rs3.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' and rownum < 7 AND INFO_DESCR LIKE '%PENGUMUMAN%' ORDER BY INFO_ID DESC"
Rs3.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' and info_name like INITCAP('%PENGUMUMAN%') or (dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)) like INITCAP('%PENGUMUMAN%') or info_name like UPPER('%PENGUMUMAN%') or (dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)) like UPPER('%PENGUMUMAN%') ORDER BY INFO_ID DESC"
Rs3.CursorType = 0
Rs3.CursorLocation = 2
Rs3.LockType = 3
Rs3.Open
Rs3_numRows = 3
no = RS3_first
x=0
while not rs3.eof and x < rs3_numRows
%>
<%=Rs3(3)%> <%=Rs3(2)%>
<%
Rs3.Movenext
x = x + 1
Wend
%>
|
|
|
|
<%
'INI UNTUK KONSULTASI PUBLIK
Set Rs2 = Server.CreateObject("ADODB.RECORDSET")
Rs2.ActiveConnection = MM_connect_String
'Rs2.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' and rownum < 7 AND INFO_NAME LIKE '%KONSULTASI%' ORDER BY INFO_ID DESC"
Rs2.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' and info_name like INITCAP('%KONSULTASI%') or (dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)) like INITCAP('%KONSULTASI%') or info_name like UPPER('%KONSULTASI%') or (dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)) like UPPER('%KONSULTASI%') ORDER BY INFO_ID DESC"
Rs2.CursorType = 0
Rs2.CursorLocation = 2
Rs2.LockType = 3
Rs2.Open
Rs2_numRows = 3
no = RS2_first
x=0
while not rs2.eof and x < rs2_numRows
%>
<%=Rs2(3)%>
<%=Rs2(2)%>
<%
Rs2.Movenext
x = x + 1
Wend
%>
|
|
|
|
|
<%
Set Rs1 = Server.CreateObject("ADODB.RECORDSET")
Rs1.ActiveConnection = MM_connect_String
'Rs1.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD-MM-YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' AND ROWNUM < 6"
' Rs1.Source = "SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' and info_descr is not null and rownum between 1 and "& nomer1 &" ORDER BY INFO_date desc"
'TAMBAHAN onOs ... yg atas asli tanpa gubahan dari saya
Rs1.Source = "select * from ( SELECT x.*, rownum as r FROM ( SELECT info_id,info_name,(dbms_lob.substr(info_descr,dbms_lob.GETLENGTH(info_descr),1)),to_char(info_date,'DD Month YYYY'),info_lang,info_type,info_file from t_info where INFO_LANG='ID' ORDER BY INFO_ID DESC ) x ) where r between 7 AND 9"
Rs1.CursorType = 0
Rs1.CursorLocation = 2
Rs1.LockType = 3
Rs1.Open
Rs1_numRows = 3
no = RS1_first
x=0
while not rs1.eof and x < rs1_numRows
%>
<%=Rs1(3)%>
<%=Rs1(2)%>
<%
Rs1.Movenext
x = x + 1
Wend
%>
Arsip Lain >>>
|
|
|
|