Solved

ADODB.Field error '80020009'

Posted on 2016-08-26
4
23 Views
Last Modified: 2016-10-04
This error come out when i'm running my code and i am really hope someone can help me on this since i am new in asp and this is not my code. i have given by my supervisor to work on this code:

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/servisdesk2.0/dashboard/main.asp, line 0
Here is my code:
<%@ language="VBscript"%>
<!--#include file="conn/conn_sybase.asp"-->
<!--#include file="conn/conn_ro.asp"-->
<!--#include file="conn/connsta.asp"-->
<!--#include file="conn/conncuti.asp"-->
<!DOCTYPE html>
<html>
  <head>
<% 
session("userid") = "840831035928" 
%>
    <meta charset="UTF-8">
    <title>PPKT | Dashboard Monitoring System</title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
    <!-- Bootstrap 3.3.4 -->
    <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />    
    <!-- FontAwesome 4.3.0 -->
    <link href="css/font-awesome.min.css" rel="stylesheet" type="text/css" />  
    <!-- Theme style -->
    <link href="dist/css/AdminLTE.min.css" rel="stylesheet" type="text/css" />
    <!-- AdminLTE Skins. Choose a skin from the css/skins 
         folder instead of downloading all of them to reduce the load. -->
    <link href="dist/css/skins/_all-skins.min.css" rel="stylesheet" type="text/css" />
    <!-- iCheck -->
    <link href="plugins/iCheck/flat/blue.css" rel="stylesheet" type="text/css" />
    <!-- Morris chart -->
    <link href="plugins/morris/morris.css" rel="stylesheet" type="text/css" />
    <!-- jvectormap -->
    <link href="plugins/jvectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" />
    <!-- Date Picker -->
    <link href="plugins/datepicker/datepicker3.css" rel="stylesheet" type="text/css" />
    <!-- Daterange picker -->
    <link href="plugins/daterangepicker/daterangepicker-bs3.css" rel="stylesheet" type="text/css" />
    <!-- bootstrap wysihtml5 - text editor -->
    <link href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css" rel="stylesheet" type="text/css" />

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
        <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
<style>

document, body {margin:0px;}
 
.iframe {
  height:870px;
        width:1400px;
        margin: none;
        padding: 0px;
        overflow: hidden;
  -moz-transform: scale(0.44, 0.2); 
  -webkit-transform: scale(0.44, 0.2); 
  -o-transform: scale(0.44, 0.2);
  -ms-transform: scale(0.44, 0.2);
   transform: scale(0.44, 0.5); 
  -moz-transform-origin: top left;
  -webkit-transform-origin: top left;
  -o-transform-origin: top left;
  -ms-transform-origin: top left;
   transform-origin: top left;
}

</style>
  </head>
  <body class="skin-blue sidebar-mini">
    
    <div class="wrapper">
      
      <header class="main-header">
        <!-- Logo -->
        <a href="index2.html" class="logo">
          <!-- mini logo for sidebar mini 50x50 pixels -->
          <span class="logo-mini">PPKT</span>
          <!-- logo for regular state and mobile devices -->
          <span class="logo-lg"><b>PPKT</b>Dashboard</span>
        </a>
        <!-- Header Navbar: style can be found in header.less -->
        <nav class="navbar navbar-static-top" role="navigation">
          <!-- Sidebar toggle button-->
          <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
            <span class="sr-only">Toggle navigation</span>
          </a>
          <div class="navbar-custom-menu">
            <ul class="nav navbar-nav">
    
              <!-- User Account: style can be found in dropdown.less -->
              <li class="dropdown user user-menu">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                 <% 
Set rsSen = Server.CreateObject("ADODB.Recordset") 
Set rsGel = Server.CreateObject("ADODB.Recordset") 
Set rsJawatan = Server.CreateObject("ADODB.Recordset") 

rsSen.Open "Select gambar,gelaran, nama From kgdpbdjs where nopeng='"&session("userid")&"'  ",connsta
rsGel.Open "Select gelaran from kgkgelar where kod='" & rsSen("gelaran")& "'",connsta
rsJawatan.Open "Select * from board_admin where nopeng = '" & session("userid")  &"' " ,conn_ro



%>
  <img src="https://campusonline2.usm.my/photo/stafpic/<%=trim(rsSen("gambar"))%>.jpg" class="user-image" alt="User Image"/>
                  
                <span class="hidden-xs"><%=session("nama")%></span>
                </a>
                <ul class="dropdown-menu">
                  <!-- User image -->
                  <li class="user-header">
                 
                    <img src="https://campusonline2.usm.my/photo/stafpic/<%=trim(rsSen("gambar"))%>.jpg" class="img-circle" alt="User Image" />
                    <p>
                     <%IF NOT rsGel.EOF THEN%><%=rsGel("gelaran")%><%ELSE%><%END IF%>&nbsp;<%=Ucase(session("nama"))%>
                      <small><%=rsJawatan("jawatan")%></small>
                    </p>
                  </li>
                
                  <!-- Menu Footer-->
                  <li class="user-footer">
                    
                    <div class="pull-right">
                      <a href="logout.asp" class="btn btn-default btn-flat">Logout</a>
                    </div>
                  </li>
                </ul>
              </li>
              <!-- Control Sidebar Toggle Button -->
             
            </ul>
          </div>
        </nav>
      </header>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
       <!--#include file="menu.asp"-->
      </aside>

      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Dashboard
            <small>Main</small>
          </h1>
          <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Dashboard</li>
          </ol>
        </section>

        <!-- Main content -->
        <section class="content">
          <!-- Small boxes (Stat box) -->
          <div class="row">
             <div class="col-lg-3 col-xs-6">
              <!-- small box -->
             <% 
              
              'rs_pp=conn.EXECUTE("SELECT COUNT(*) as jum_pp FROM kgdpbdjs a, kgkjwtdd b where a.jwlantik=b.kod AND a.tptugas in ('00735','00748','00760') AND tfrekod <> '2'")
        rs_pp=connsta.EXECUTE("SELECT COUNT(*) as jum_pp FROM kgdpbdjs a, kgkjwtdd b where a.jwlantik=b.kod AND a.tptugas in ('00735') AND tfrekod <> '2'")
        rs_tr=connsta.EXECUTE("SELECT COUNT(*) as jum_tr FROM kgdpbdjs a, kgkjwtdd b where a.jwlantik=b.kod AND a.tptugas in ('00748') AND tfrekod <> '2'")
        rs_kk=connsta.EXECUTE("SELECT COUNT(*) as jum_kk FROM kgdpbdjs a, kgkjwtdd b where a.jwlantik=b.kod AND a.tptugas in ('00760') AND tfrekod <> '2'")
        rs_ippt=connsta.EXECUTE("SELECT COUNT(*) as jum_ippt FROM kgdpbdjs a, kgkjwtdd b WHERE ( b.klas in ('F') OR b.kodgaji in ('B44','B27','B17','B22') ) AND a.jwlantik=b.kod AND a.tptugas in ('00734') AND tfrekod <> '2'")
      
        hari_ini = month(now)&"/"&day(now)&"/"&year(now) 
        
        rs_cuti_pp=conncuti.EXECUTE("SELECT COUNT(nopeng) as staf_cuti_pp FROM kgdcuti WHERE thmula <= '"& hari_ini &"' AND thhingga >= '"& hari_ini &"' AND kod_jbtn in ('00735') ")
        rs_cuti_tr=conncuti.EXECUTE("SELECT COUNT(nopeng) as staf_cuti_tr FROM kgdcuti WHERE thmula <= '"& hari_ini &"' AND thhingga >= '"& hari_ini &"' AND kod_jbtn in ('00748') ")
        rs_cuti_kk=conncuti.EXECUTE("SELECT COUNT(nopeng) as staf_cuti_kk FROM kgdcuti WHERE thmula <= '"& hari_ini &"' AND thhingga >= '"& hari_ini &"' AND kod_jbtn in ('00760') ")
        set rs_ippt_staf=Server.CreateObject("ADODB.RecordSet")
        rs_ippt_staf.OPEN "SELECT * FROM kgdpbdjs a, kgkjwtdd b WHERE ( b.klas in ('F') OR b.kodgaji in ('B44','B27','B17','B22') ) AND a.jwlantik=b.kod AND a.tptugas = '00734'  AND tfrekod <> '2'" ,connsta,1,1
        IF NOT rs_ippt_staf.EOF THEN
          DO WHILE NOT rs_ippt_staf.EOF 
            nopeng = rs_ippt_staf("nopeng")
            set rs_cuti =Server.CreateObject("ADODB.RecordSet")
            rs_cuti.open "SELECT * FROM kgdcuti WHERE nopeng ='"& nopeng &"' AND thmula <= '"& hari_ini &"' AND thhingga >= '"& hari_ini &"' AND kod_jbtn='00734'",conncuti,1,1
            IF NOT rs_cuti.EOF THEN
              staf_cuti_ippt = staf_cuti_ippt + 1
              sen = sen &","& nopeng
            END IF
            rs_cuti.CLOSE
          rs_ippt_staf.MOVENEXT
          x = x+1
          LOOP
        END IF
        
        strenght_pp   = ( rs_pp("jum_pp") - rs_cuti_pp("staf_cuti_pp") ) / rs_pp("jum_pp") * 100
        strenght_tr   = ( rs_tr("jum_tr") - rs_cuti_tr("staf_cuti_tr") ) / rs_tr("jum_tr") * 100
        strenght_kk   = ( rs_kk("jum_kk") - rs_cuti_kk("staf_cuti_kk") ) / rs_kk("jum_kk") * 100
        strenght_ippt         = ( rs_ippt("jum_ippt") - staf_cuti_ippt ) / rs_ippt("jum_ippt") * 100
        strenght_pp   = FormatNumber(strenght_pp,0)&"%"
        strenght_tr   = FormatNumber(strenght_tr,0)&"%"
        strenght_kk   = FormatNumber(strenght_kk,0)&"%"
        strenght_ippt         = FormatNumber(strenght_ippt,0)&"%"
        
        set rs_trkh_cuti=Server.CreateObject("ADODB.RecordSet")
        rs_trkh_cuti.OPEN "SELECT * FROM d_cuti WHERE day(trkh_cuti) = '"&day(NOW)&"' AND month(trkh_cuti) = '"&month(NOW)&"' AND year(trkh_cuti) = '"&year(NOW)&"' " ,conn_ro,1,1
        IF NOT rs_trkh_cuti.EOF THEN
          cuti_umum = "ye"
          catatan = "<font color='#FF0000' size='4' face='Trebuchet MS'>CUTI </font><br><font color='#FF0000' size='1' face='Trebuchet MS'>"&rs_trkh_cuti("catatan")&"</font>"
        END IF
        
                    set rs_trkh_cutikk=Server.CreateObject("ADODB.RecordSet")
        rs_trkh_cutikk.OPEN "SELECT * FROM d_cuti_kk WHERE day(trkh_cuti) = '"&day(NOW)&"' AND month(trkh_cuti) = '"&month(NOW)&"' AND year(trkh_cuti) = '"&year(NOW)&"' " ,conn_ro,1,1
        IF NOT rs_trkh_cutikk.EOF THEN
          cuti_umumkk = "ye"
          catatankk = "<font color='#FF0000' size='4' face='Trebuchet MS'>CUTI </font><br><font color='#FF0000' size='1' face='Trebuchet MS'>"&rs_trkh_cutikk("catatan")&"</font>"
        END IF
        rs_trkh_cuti.CLOSE
        rs_trkh_cutikk.CLOSE
      %>
             <div class="small-box bg-yellow">
                <div class="inner"><%IF Weekday(now,1) = 1 OR Weekday(now,1) = 7 OR cuti_umum = "ye" THEN%><h3>BERCUTI</font></h3><%ELSE%>
                  <h3><%'=rs_pp("jum_pp")%><%=strenght_pp%></h3><%END IF%>
                  <p>Strength PPKT (Induk)</p> 
                 </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                <a href="main_perjawatan.asp" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
              </div>
              </div>
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-aqua">
                <div class="inner"><%IF Weekday(now,1) = 1 OR Weekday(now,1) = 7 OR cuti_umum = "ye" THEN%><h3>BERCUTI</font></h3><%ELSE%>
                  <h3><%=strenght_tr%></h3><%END IF%>
                  <p>Strength PPKT (Kejuruteraan)</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                <a href="main_perjawatan.asp" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
              </div>
            </div><!-- ./col -->
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-green">
                <div class="inner"><%IF Weekday(now,1) = 6 OR Weekday(now,1) = 7 OR cuti_umumkk = "ye" THEN%><h3>BERCUTI</font></h3><%ELSE%>
                  <h3><%=strenght_kk%></h3><%END IF%>
                  <p>Strength PPKT (Kesihatan)</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                <a href="main_perjawatan.asp" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
              </div>
            </div><!-- ./col -->

-----------------BAHAGIAN STRENGTH IPPT-------------------


            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-red">
                <div class="inner"><%IF Weekday(now,1) = 1 OR Weekday(now,1) = 7 OR cuti_umum = "ye" THEN%><h3>BERCUTI</font></h3><%ELSE%>
                  <h3><%=strenght_ippt%></h3><%END IF%>
                  <p>Strength PPKT (IPPT)</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                <a href="main_perjawatan.asp" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
              </div>
            </div><!-- ./col -->
           
          </div><!-- /.row -->
               <!-- Main row -->
          <div class="row">
            <!-- Left col -->
            <section class="col-lg-7 connectedSortable">
              <!-- Custom tabs (Charts with tabs)-->
              <div class="nav-tabs-custom">
                <!-- Tabs within a box -->
                <ul class="nav nav-tabs pull-right">
                  <li><a href="#ippt" data-toggle="tab">IPPT</a></li>
                  <li><a href="#kesihatan" data-toggle="tab">Kesihatan</a></li>
                  <li><a href="#kejuruteraan" data-toggle="tab">Kejuruteraan</a></li>
                  <li class="active"><a href="#induk" data-toggle="tab">Induk</a></li>
                   
                  <li class="pull-left header"><i class="fa fa-inbox"></i> Diari PPKT</li>
                </ul>
                <div class="tab-content no-padding">
                  <!-- Morris chart - Sales -->
                  <div class="diari tab-pane" id="kesihatan" style="position: relative; height: 300px;"> 
          <!--#include file="diari/todayppktkk.asp"--></div>
                  
                  <div class="diari tab-pane active" id="induk" style="position: relative; height: 300px;"> 
          <!--#include file="diari/todayenovate.asp"--></div>
    
                 <div class="diari tab-pane" id="kejuruteraan" style="position: relative; height: 300px;"> 
         <!--#include file="diari/todayppkt.asp"--></div>
              
              </div>
              </div><!-- /.nav-tabs-custom -->

           
              <!-- Chat box -->
              <div class="box box-success">
                <div class="box-header">
                  <i class="fa fa-comments-o"></i>
                  <h3 class="box-title">Network Weathermap Kampus Induk</h3>
                 <br>
                 <a href="http://www.nettraffic.usm.my/USMNet.html" target="_blank">View Full Weather Map</a>
                </div>     
                      
                      <div style="border:1.5px solid #000;">
                      <div id="contentframe" style="position:relative; top: 0px; left: -380px; display:block;">
<iframe src="http://www.nettraffic.usm.my/USMNet.html" frameborder="0" scrolling="no" width="1380px" height="800" style=transform:scale(0.45,0.8);"></iframe> 
</div>
                 
  </div><!-- /.box (chat box) -->
                
              <!-- Chat box -->
              <div class="box box-success">
                <div class="box-header">
                  <i class="fa fa-comments-o"></i>
                  <h3 class="box-title">Network Weathermap Kampus Kejuruteraan</h3>
                 <br>
                  <a href="http://10.101.130.79/weathermap.html" target="_blank">View Full Weather Map</a>
                  </div>
 
<div style="border:1.5px solid #000;">             
 <div id="contentframe" style="position:relative; top: 0px; left: -380px;">
<iframe src="http://10.101.130.79/weathermap.html" frameborder="0" scrolling="no" width="1380" height="845" style="transform: scale(0.6,0.9);"></iframe>
</div>
              
</div><!-- /.box (chat box) -->

           <!-- Chat box -->
              <div class="box box-success">
                <div class="box-header">
                  <i class="fa fa-comments-o"></i>
                  <h3 class="box-title">Network Weathermap Kampus Kesihatan</h3>
                  <br>
                  <a href="http://10.5.1.55/KKUSMnet.html" target="_blank">View Full Weather Map</a> 
                </div>
              
<div style="border:1.5px solid #000;"> 
                <div id="contentframe" style="position:relative; top: 80px; left: -380px;">
<iframe src="http://10.5.1.55/KKUSMnet.html" frameborder="0" scrolling="no" width="1380" height="1200" style="transform: scale(0.4,0.8);"></iframe>
</div>

               
</div><!-- /.box (chat box) -->
    
        <!-- Chat box -->
              <div class="box box-success">
                <div class="box-header">
                  <i class="fa fa-comments-o"></i>
                  <h3 class="box-title">Network Weathermap IPPT</h3>
                  <br>
                  <a href="http://nms.amdi.usm.edu.my/" target="_blank">View Full Weather Map</a>  
                </div>
                 
<div style="border:1.5px solid #000;">              
 <div id="contentframe" style="position:relative; top: 0px; left: -370px;">
<iframe src="http://nms.amdi.usm.edu.my/" frameborder="0" scrolling="no" width="1360" height="800" display:block; style="transform: scale(0.45,0.9);"></iframe>
</div>

</div><!-- /.box (chat box) -->
            

            </section><!-- /.Left col -->
            <!-- right col (We are only adding the ID to make the widgets sortable)-->
             <section class="col-lg-5 connectedSortable">
          
------------BAHAGIAN KOTAK SERVIS DESK------------------------------------

          <!-- Info Boxes Style 2 -->
          <%  SET rs_aduan_induk = conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_induk FROM d_aduan_enovate WHERE year(trkh_aduan) = '2015'")
        SET rs_aduan_induk_semasa = conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_induk_semasa FROM d_aduan_enovate WHERE day(trkh_aduan) = '"&day(Now())&"' AND month(trkh_aduan) = '"&month(Now())&"' AND year(trkh_aduan) = '"&year(Now())&"' ")   
            
        SET rs_aduan_kejut = conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_kejut FROM d_aduan_ppkt WHERE year(trkh_aduan) = '2015'")
        SET rs_aduan_kejut_semasa= conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_kejut_semasa FROM d_aduan_ppkt WHERE day(trkh_aduan) = '"&day(Now())&"' AND month(trkh_aduan) = '"&month(Now())&"' AND year(trkh_aduan) = '"&year(Now())&"'")        
        SET rs_aduan_kesit = conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_kesit FROM d_aduan_ppktkk WHERE year(trkh_aduan) = '2015'")
        SET rs_aduan_kesit_semasa= conn_ro.EXECUTE ("SELECT COUNT(no_tiket) AS jum_aduan_kesit_semasa FROM d_aduan_ppktkk WHERE day(trkh_aduan) = '"&day(Now())&"' AND month(trkh_aduan) = '"&month(Now())&"' AND year(trkh_aduan) = '"&year(Now())&"'")
        
        SET rs_pohon_induk = conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_induk FROM SPO_d_permohonan_enovate WHERE year(trkh_pohon) = '2015'")
        SET rs_pohon_induk_semasa = conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_induk_semasa FROM SPO_d_permohonan_enovate WHERE day(trkh_pohon) = '"&day(Now())&"' AND month(trkh_pohon) = '"&month(Now())&"' AND year(trkh_pohon) = '"&year(Now())&"'")       
        SET rs_pohon_kejut = conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_kejut FROM SPO_d_permohonan_ppkt WHERE year(trkh_pohon) = '2015'")
        SET rs_pohon_kejut_semasa= conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_kejut_semasa FROM SPO_d_permohonan_ppkt WHERE day(trkh_pohon) = '"&day(Now())&"' AND month(trkh_pohon) = '"&month(Now())&"' AND year(trkh_pohon) = '"&year(Now())&"'")       
        SET rs_pohon_kesit = conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_kesit FROM SPO_d_permohonan_ppktkk WHERE year(trkh_pohon) = '2015'")
        SET rs_pohon_kesit_semasa = conn_ro.EXECUTE ("SELECT COUNT(id_pohon) AS jum_pohon_kesit_semasa FROM SPO_d_permohonan_ppktkk WHERE day(trkh_pohon) = '"&day(Now())&"' AND month(trkh_pohon) = '"&month(Now())&"' AND year(trkh_pohon) = '"&year(Now())&"'")        

    %>
              <div class="info-box bg-yellow">
                <span class="info-box-icon"><i class="ion-ios-chatbubble-outline"></i></span>
                <div class="info-box-content">
                  <span class="info-box-text">Servisdesk@PPKT Induk</span>
          <span class="progress-description">
                   Aduan : <%=rs_aduan_induk_semasa("jum_aduan_induk_semasa")%>/<%=rs_aduan_induk("jum_aduan_induk")%>
                  </span>
                  <div class="progress">
                    <div class="progress-bar" style="width: 20%"></div>
                  </div>                  
                  <span class="progress-description">
                   Permohonan : <%=rs_pohon_induk_semasa("jum_pohon_induk_semasa")%>/<%=rs_pohon_induk("jum_pohon_induk")%>
                  </span>
                  
                  
                </div><!-- /.info-box-content -->
              </div><!-- /.info-box -->
              <div class="info-box bg-aqua">
                <span class="info-box-icon"><i class="ion-ios-chatbubble-outline"></i></span>
                <div class="info-box-content">
                  <span class="info-box-text">Servisdesk@PPKT Kejuruteraan</span>
          <span class="progress-description">Aduan : <%=rs_aduan_kejut_semasa("jum_aduan_kejut_semasa")%>/<%=rs_aduan_kejut("jum_aduan_kejut")%>
                  </span>
                  <div class="progress">
                    <div class="progress-bar" style="width: 20%"></div>
                  </div>                  
                  <span class="progress-description">
                   Permohonan : <%=rs_pohon_kejut_semasa("jum_pohon_kejut_semasa")%>/<%=rs_pohon_kejut("jum_pohon_kejut")%>
                  </span>
                </div><!-- /.info-box-content -->
              </div><!-- /.info-box -->
              <div class="info-box bg-green">
                <span class="info-box-icon"><i class="ion-ios-chatbubble-outline"></i></span>
                <div class="info-box-content">
                  <span class="info-box-text">Servisdesk@PPKT Kesihatan</span>
          <span class="progress-description">Aduan : <%=rs_aduan_kesit_semasa("jum_aduan_kesit_semasa")%>/<%=rs_aduan_kesit("jum_aduan_kesit")%>
                  </span>
                  <div class="progress">
                    <div class="progress-bar" style="width: 20%"></div>
                  </div>                  
                  <span class="progress-description">
                   Permohonan : <%=rs_pohon_kesit_semasa("jum_pohon_kesit_semasa")%>/<%=rs_pohon_kesit("jum_pohon_kesit")%>
                  </span>
                </div><!-- /.info-box-content -->
              </div><!-- /.info-box -->

              
             
             <div class="info-box bg-red">
                <span class="info-box-icon"><i class="ion-ios-chatbubble-outline"></i></span>
                <div class="info-box-content">
                  <span class="info-box-text">Servisdesk@PPKT IPPT</span>
          <span class="progress-description">Aduan : 
                  </span>
                  <div class="progress">
                    <div class="progress-bar" style="width: 20%"></div>
                  </div>                  
                  <span class="progress-description">
                   Permohonan : 
                  </span>
                </div><!-- /.info-box-content -->
              </div><!-- /.info-box -->
           

 <!-- solid sales graph -->
              <div class="box box-solid bg-teal-gradient">
                <div class="box-header">
                  <i class="fa fa-th"></i>
                  <h3 class="box-title">uChannel@USM Video Growth</h3>
                  <div class="box-tools pull-right">
                    <button class="btn bg-teal btn-sm" data-widget="collapse"><i class="fa fa-minus"></i></button>
                    <button class="btn bg-teal btn-sm" data-widget="remove"><i class="fa fa-times"></i></button>
                  </div>
                </div>
                <div class="box-body border-radius-none">
                  <div class="chart" id="line-chart" style="height: 250px;"></div>
                </div><!-- /.box-body -->
        
                <div class="box-footer no-border">
                  <div class="row">
                    <div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
                      <input type="text" class="knob" id="cpupp" data-readonly="true" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">(Main Campus) CPU</div>
                    </div><!-- ./col -->
                    <div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
                      <input type="text" class="knob" id="memorypp" data-readonly="true" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">Memory</div>
                    </div><!-- ./col -->
                    <div class="col-xs-4 text-center">
                      <input type="text" class="knob" id="storagepp" data-readonly="true" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">Storage Usage</div>
                    </div><!-- ./col -->
                  </div><!-- /.row -->
          <hr>
           <div class="row">
                    <div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
                      <input type="text" class="knob" id="cpueng" data-readonly="true" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">(Eng. Campus) CPU</div>
                    </div><!-- ./col -->
                    <div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
                      <input type="text" class="knob" id="memoryeng" data-readonly="true" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">Memory</div>
                    </div><!-- ./col -->
                    <div class="col-xs-4 text-center">
                      <input type="text" class="knob" id="storageeng" data-readonly="false" data-width="60" data-height="60" data-fgColor="#39CCCC"/>
                      <div class="knob-label">Storage Usage</div>
            
                    </div><!-- ./col -->
                  </div><!-- /.row --> 
                </div><!-- /.box-footer -->
              </div><!-- /.box -->
             <!-- PRODUCT LIST -->
              <div class="box box-primary">
999999                <div class="box-header with-border">
                  <h3 class="box-title">Recently Activities (uchannel@USM)</h3>
                  <div class="box-tools pull-right">
                    <button class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
                    <button class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
                  </div>
                </div><!-- /.box-header -->
                <div class="box-body">
                  <ul class="products-list product-list-in-box" id="boxx">
                    
                  </ul>
                </div><!-- /.box-body -->
                <div class="box-footer text-center">
                  <!--<a href="javascript::;" class="uppercase">View All Products</a> -->
                </div><!-- /.box-footer -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
      </div><!-- /.content-wrapper -->
       

          
      

            </section><!-- right col -->
          </div><!-- /.row (main row) -->

        </section><!-- /.content -->
      </div><!-- /.content-wrapper -->
      <footer class="main-footer">
        <div class="pull-right hidden-xs">
         
        </div>
        <div align="center">
        © 2015-<%=Year(Now)%> Hakcipta Terpelihara Pusat Pengetahuan Komunikasi & Teknologi Universiti Sains Malaysia.
      </footer>
      
     <!-- Add the sidebar's background. This div must be placed
           immediately after the control sidebar -->
      <div class='control-sidebar-bg'></div>
    </div><!-- ./wrapper -->

    <!-- jQuery 2.1.4 -->
    <script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- jQuery UI 1.11.4 -->
    <script src="https://code.jquery.com/ui/1.11.4/jquery-ui.min.js" type="text/javascript"></script>
    <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
    <script>
      $.widget.bridge('uibutton', $.ui.button);
    </script>
    <!-- Bootstrap 3.3.2 JS -->
    <script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>    
    <!-- Morris.js charts -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
    <script src="plugins/morris/morris.min.js" type="text/javascript"></script>
    <!-- Sparkline -->
    <script src="plugins/sparkline/jquery.sparkline.min.js" type="text/javascript"></script>
    <!-- jvectormap -->
    <script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js" type="text/javascript"></script>
    <script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js" type="text/javascript"></script>
    <!-- jQuery Knob Chart -->
    <script src="plugins/knob/jquery.knob.js" type="text/javascript"></script>
    <!-- daterangepicker -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.2/moment.min.js" type="text/javascript"></script>
    <script src="plugins/daterangepicker/daterangepicker.js" type="text/javascript"></script>
    <!-- datepicker -->
    <script src="plugins/datepicker/bootstrap-datepicker.js" type="text/javascript"></script>
    <!-- Bootstrap WYSIHTML5 -->
    <script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js" type="text/javascript"></script>
    <!-- Slimscroll -->
    <script src="plugins/slimScroll/jquery.slimscroll.min.js" type="text/javascript"></script>
    <!-- FastClick -->
    <script src='plugins/fastclick/fastclick.min.js'></script>
    <!-- AdminLTE App -->
    <script src="dist/js/app.min.js" type="text/javascript"></script>    

    <!-- AdminLTE dashboard demo (This is only for demo purposes) -->
    <script src="dist/js/pages/dashboard.js" type="text/javascript"></script>    
    
    <!-- AdminLTE for demo purposes -->
    <script src="dist/js/demo.js" type="text/javascript"></script>
  </body>
</html>

Open in new window


p/s: I'm really someone can help me fix this since i am new in asp
0
Comment
Question by:Nur Amirah Roslan
4 Comments
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41771380
are you able to trace which line of codes causing the error?

>>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

in general, you're referring to a recordset's field value but apparently don't have any record returned to the recordset result. Hence, before you referring to the recordset's field value, you need to verify whether the recordset is empty. like:

or original codes:
<%
        'do your stuff here
         response.write rs("yourfield")
%>

Open in new window

adding a check;
<%
    if rs.eof = false then
        'do your stuff here
         response.write rs("yourfield")
   end if
%>

Open in new window

0
 

Author Comment

by:Nur Amirah Roslan
ID: 41779195
thank you for your respond...the problem has solved
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 41827693
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now