Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1724
  • Last Modified:

Object doesn't support this property or method 'eof'

I have the following code which keeps throwing the error

Microsoft VBScript runtime  error '800a01b6'

Object doesn't support this property or method: 'eof'


Please help.

                  nString = "select name from seminar where seminarid = '" & vSeminarID & "'"                             
            
              RS=obj_conn.Execute(nString)
            
            if not (RS.eof and RS.bof) then
                 Do while not RS.eof
                 Response.write (RS("name"))
          RS.Movenext
                 Loop
            end if
              response.write (vSeminarID)
                  On Error Resume Next
                  obj_conn.Execute(vSQLString)
            end if
0
drai123
Asked:
drai123
  • 2
1 Solution
 
sajuksCommented:
try changing
     RS=obj_conn.Execute(nString)
to
SET RS=obj_conn.Execute(nString)
0
 
GawaiCommented:
where your DB connecting sting ?


0
 
GawaiCommented:
and then try
If (RS.EOF = False) And (RS.BOF = False) Then  ' i think this line is not important here


Do while not RS.eof
                 Response.write (RS("name"))
          RS.Movenext
               Loop
          end if
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now