Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    53

    Unanswered: error (EOF or BOF)

    this is a new problem.
    below are the coding:



    <%@LANGUAGE="VBSCRIPT"%>
    <!--#include file="Connections/sambung.asp" -->

    <%
    Dim getid
    Dim idaduan

    Dim sq
    Dim rs
    Dim rs1
    Dim db
    Dim nama
    getid=session("id")
    set db=Server.CreateObject("ADODB.Connection")
    db.Open"sambung"

    sq="SELECT namastaffuitm FROM staffIT WHERE nostaffuitm='" & getid &"'"
    set rs=db.execute(sq)
    nama=rs("namastaffuitm")

    'sq2="SELECT id_aduan, status_id,tarikhmasa,arahan FROM tb_aduan WHERE arahan='" &nama& "'"
    'set rs1=db.execute(sq2)
    'idaduan=rs1("id_aduan")



    Dim Recordset1
    Dim Recordset1_numRows


    Set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.ActiveConnection = MM_sambung_STRING
    Recordset1.Source = "SELECT id_aduan, tarikhmasa, arahan, status_id FROM tb_aduan WHERE arahan='" & nama & "'"
    Recordset1.CursorType = 0
    Recordset1.CursorLocation = 2
    Recordset1.LockType = 1
    Recordset1.Open()

    Recordset1_numRows = 0


    %>


    the problem is it cannot view the data.the system cannot find any data that match the expression below eventhough there data is available in the database

    i always get BOF or EOF error.can somebody help me!!!!!!!!!!!!!!!!!!1

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    If you do a "Response.Write nama" after:

    nama=rs("namastaffuitm")

    Is a value displayed?
    That which does not kill me postpones the inevitable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •