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

If you do a "Response.Write nama" after:

nama=rs("namastaffuitm")

Is a value displayed?