Tolong pilih kategori sesuai, jenis posting (diskusi atau bukan) dan sertakan tag/topik yang sesuai seperti komputer, java, php, mysql, dll. Promosi atau posting tidak pada tempatnya akan kami hapus!
- Bagi Anda yang ingin mendaftar, baca link berikut:
http://diskusiweb.com/discussion/50491/how-to-registrasi-diskusiweb-com-baca-ini-terlebih-dahulu
- Cara menyisipkan kode program supaya tampil rapi dan terformat dengan baik di diskusiweb.com: http://www.diskusiweb.com/discussion/50415/cara-menyisipkan-kode-program-di-diskusiweb-com
- Cara posting gambar/image di post Anda: http://www.diskusiweb.com/discussion/47345/cara-menyisipkan-menyertakan-image-pada-posting/p1

menampilkan report by userId

teman2 mohon bantuan perintah untuk menampilkan request sesuai tgl dari user yg aktif ini gmana ya? misalnya ada user A, mw ngeluarin rekapan hasil yg dia entri dari range tgl skian smpai tgl skian.. soalnya d tampilan sya itu dia nampilin smua hasil entri dari smua operator yg ada

Comments

  • edited January 30
    kan tinggal pake WHERE di query nya ...

    SELECT ...
    FROM ...
    WHERE field_user_id = "id_user_A" AND field_tanggal BETWEEN "yyyy-mm-dd1" AND "yyyy-mm-dd2"
  • sdah bang, tapi pas runningnya itu loading klamaan smpai akhirnya timed out
  • ya di posting to mas ...

    elo nulis query kaya apa
    koding elo kaya apa
  • set rs = server.createobject("adobdb.recordset")
    rs.open "SELECT * From dtPelayanan where id = "&idopr&" and tgl_daftar between #"&tgla&"# and #"&tglb&"#, cnndb, 3, 2
  • mas ...

    bagaimana mungkin gw bisa baca "kenapa query elo jadi lambat"
    hanya dgn modal 1-2 baris koding doang ?
  • edited February 7
    <%
    set cnndb=server.createobject("adodb.connection")
    cnndb.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("main.mdb")
    on error resume next


    tgla=request("tgla")
    tglb=request("tglb")
    kat=request("kat")
    idopr=request("idopr")


    on error resume next
    if kat=1 then
    set rs=server.createobject("adodb.recordset")
    rs.open "SELECT * from dtPelayanan where idopr = "&idopr&" and tgl_invest between #"&tgla&"# and #"&tglb&"#", cnndb, 3, 2

    ElseIf kat=2 then
    set rs=server.createobject("adodb.recordset")
    rs.open "SELECT * from dtPelayanan where idopr = "&idopr&" and tgl_cair Between #"&tgla&"# and #"&tglb&"#", cnndb,3,2
    end if
    'set rs1=server.createobject("adodb.recordset")
    ' rs1.open "SELECT count(*) as total from ktpel where tgl=#"&nilai&"#", cnndb,3,2
    aksi=request("aksi")
    if aksi="" then aksi="daftar"
    if aksi="daftar" then

    %>
    <html>
    <head><title>CV. Ubay Jaya</title></head>
    <head><link rel="stylesheet" type="text/css" href="menu3.css"></head>

    <body style="background:url(image/cengkeh.jpg); background-attachment:fixed; background-repeat:no-repeat; background-size:100% 100%;">
    <table cellpadding="0" cellspacing="0" border="0" width="100%" bgcolor="#047595" style="-moz-box-shadow:0 0 10px #333;-webkit-box-shadow:0 0 10px #333;box-shadow:0 0 10px #333;">
    <tr>
    <td> </td>
    <td> </td>
    <td align="right">
    <br> 
    <font color=#fffff face=calibri style="font-size:14px;text-shadow:2px 0px 2px #030303;">CV. Ubay Jaya</font>
    </td>
    <td> </td>
    </tr>
    </table>
    <table cellpadding="0" cellspacing="0" border="0" width="100%" >
    <tr>
    <td width="2%"> </td>
    <td></td>
    <td></td>
    <td width="2%"> </td>
    </tr>
    </table>
    <table cellpadding="0" cellspacing="0" border="0" width="100%" >
    <tr>
    <td width="15%" background="img/backMenu.png" valign="top">
    <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td>
    <ul id="nav">
    <li id="nav-home"><a href="pemohon.asp"><font color="#FFFFFF">    Home</a></li>
    </td>
    </tr>
    <tr>
    <td>
    <ul id="nav">
    <li id="nav-home"><a href=daftar.asp?idopr=<%=""&idopr&""%>><font color="#FFFFFF">    Manifest</a></li>
    </ul>
    </td>
    </tr>
    <tr>
    <td>
    <ul id="nav">
    <li id="nav-home"><a href="laporan.asp?idopr=<%=""&idopr&""%>"><font color="#FFFFFF">    Report</a></li>
    </ul>
    </td>
    </tr>
    <tr><td> </td></tr>
    <tr>
    <td>

    </td>
    </tr>
    </table>
    </td>
    <td width="2%"> </td>
    <td width="81%" background="img/backwelcome.png" valign="top" >
    <table cellpadding="0" cellspacing="0" border="0" width="100%" align="center" height="100%">
    <tr valign="top" >
    <td bgcolor="#b0aeae" style="-moz-box-shadow:0 0 10px #333;-webkit-box-shadow:0 0 10px #333;box-shadow:0 0 10px #333;">    
    <font color=#fffff face=calibri style="font-size:20px;text-shadow:2px 0px 2px #030303;">Data yang ditemukan :</font>
    </td>
    <td> </td>
    <td><%response.write "<a href=excel.asp?tgla="&tgla&"&tglb="&tglb&"&kat="&kat&"><font face=verdana size=3><b>Excel</b></font></a></td>"%>
    </tr>
    <tr valign="top" colspan=3>
    <td>
    <br>
    <table cellspacing=0 cellpadding=0 border=1 width="95%" align="center">
    <tr><th width="10"><font face=verdana size=2>No</font></th>
    <th width="100"><font face=verdana size=2>Id</font></th>
    <th width="15"><font face=verdana size=2>Nama Nasabah</font></th>
    <th width="16"><font face=verdana size=2>Kelurahan</font></th>
    <th width="16"><font face=verdana size=2>No HP</font></th>
    <th width="16"><font face=verdana size=2>Modal</font></th>
    <th width="100"><font face=verdana size=2>Pencairan</font></th>
    <th width="100"><font face=verdana size=2>Tgl Invest</font></th>
    <th width="100"><font face=verdana size=2>Tgl Pencairan</font></th>
    <th width="100"><font face=verdana size=2>Status</font></th>
    <th width="100"><font face=verdana size=2>Ket</font></th>
    </tr>
    <%
    on error resume next
    i=1
    do until rs.eof
    response.write "<tr align=center><td><font face=arial style=font-size:11px>" & i & "</font></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("id")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("nama")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("nmkel")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("nohp")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("modal")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("hasilInvest")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("tgl_invest")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("tgl_cair")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("status")&"</font></a></td>"
    response.write "<td ><font face=arial style=font-size:11px>" & rs("ket")&"</font></a></td></tr>"
    rs.movenext
    i=i+1
    loop
    rs.close
    %>
    </table>



    </td>
    </tr>
    <tr valign="top" align="justify">
    <td>
    </tr>
    </table>
    </table>
    </td>
    </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td width="20%" background="img/backMenu.png" valign="top">  </td>
    <td width="2%"> </td>
    <td width="76%" background="img/backwelcome.png" valign="top" > </td>
    <td width="2%"> </td>
    </tr>
    </table>

    <%end if%>

    seperti itu mas, mohon di koreksi y...
  • normal sih alur koding nya ...

    pertanyaannya jadi :
    - table elo sudah pake index ?
    - field yg elo index apa saja ?
    - type field tgl_cair & tgl_invest apa ?
  • index blum ad bang, type fieldnya date/time
  • skarang sdah sya index bang, sya menggunakan database access.. selanjutnya bang? mohon petunjuk
  • lha ?
    masalah elo kan "runningnya itu loading klamaan smpai akhirnya timed out"

    sudah berubah atau belum setelah di index ?
  • masih sama bang
  • seperti ini keterangan yg keluar d browser bang

    Active Server Pages error 'ASP 0113'

    Script timed out

    /ubayJaya/laporan2.asp

    The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
  • edited February 8
    ndak perlu ganti seting limit waktu.
    itu baru dilakukan kalo bener2 perlu.

    ada berapa banyak datanya ?

    ndak perlu pake koding dulu, coba langsung pake access nya.
    coba query yg di atas elo jalankan.

    SELECT * from dtPelayanan where idopr = ... and tgl_invest between #...# and #...#

    atau

    SELECT * from dtPelayanan where idopr = ... and tgl_cair Between #...# and #...#

    ganti isi parameter nya dengan data yg sesuai

    hasilnya juga lama keluarnya ?
  • baik pak sya coba, tp maaf ada pertanyaan baru. aplikasi ini sya upload k iIs wndows 10, sukses running smpai k menu login. tp stelah d isi username dn password keterangannya username dn password slah, pdhal username dn pssword itu yg sering sya gunakan utk uji coba d laptop windows 7. apa d windows 10 perlu ad settingan tambahan untuk bisa mengenali script?
  • bisa debugging kan ?
    coba di debug aja, step-by-step script nya di eksekusi
    kan keliatan salahnya di mana

    https://weblogs.asp.net/dixin/debugging-classic-asp-with-visual-studio

    kalo user yg dipake ndak bisa login bisa macam-macam masalahnya
    dan bisa berunut ...

    kemungkinan besar karena gagal connect ama db nya, ya otomatis gagal ambil data

    nah gagal connect itu juga bisa karena
    masalah path,
    masalah privilege user terhadap folder dan/atau file
    masalah firewall
    masalah driver oledb yg ndak ada/ndak cocok/salah setting

    repot kalo main tebak-tebakan
    jadi lebih baik di debug aja
    elo bisa liat proses jalannya script dan tau gagal nya di mana
Sign In or Register to comment.