title: Operation is not allowed when the object is closed (Object is not closed)
body: <p>The following code, is generating that error.</p>
  
  <pre><code>Set getList = Server.CreateObject("ADODB.Command")
  getList.ActiveConnection=EV_WikiConn
  getList.Prepared = true
  getList.commandtext= "declare @Lookup table(Id int identity(1, 1) , SongTitle nvarchar(512) ) 
  insert into @Lookup(SongTitle)select * from ( values ('Deuce')) as x(a) 
  select A.AlbumName, S.SongTitle , S.Writers , S.Vocals , S.SID , S.TheTime 
  from Albums A inner join Songs S on A.AID = S.AID inner join @Lookup L on L.SongTitle = S.SongTitle order by L.Id"
  set rsList = getList.execute
  while not rsList.eof ' Error is on this line here.
  </code></pre>
  
  <p>I added this code here</p>
  
  <pre><code>Set getList = Server.CreateObject("ADODB.Command")
  getList.ActiveConnection=EV_WikiConn
  getList.Prepared = true
  getList.commandtext= "declare @Lookup table(Id int identity(1, 1) , SongTitle nvarchar(512) ) 
  insert into @Lookup(SongTitle)select * from ( values ('Deuce'),('Strutter'),('Parasite')) as x(a) 
  select A.AlbumName, S.SongTitle , S.Writers , S.Vocals , S.SID , S.TheTime 
  from Albums A inner join Songs S on A.AID = S.AID inner join @Lookup L on L.SongTitle = S.SongTitle order by L.Id"
  set rsList = getList.execute
  If rsList.State &lt;&gt; adStateOpen Then
  While rsList.State &lt;&gt; adStateOpen
  Set rsList = rsList.NextRecordset
  
  rsList.movenext
  wend
  end if
  </code></pre>
  
  <p>This makes it run, however, I only get one record, instead of the 10 that is in the actual form. So, this is not going to work, but wanted to show what I have tried so far.</p>