Results 1 to 2 of 2

Thread: Simple RecordSet Q

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    57

    Red face

    I'm using an ftp class that gets a directory list
    into a disconnected recordset
    but when i have the recordset I can't get a string out of it to put into a variable.
    dim rs as recordset
    rs = oFTP.getdirectorylist
    rs.open
    rs.movefirst
    dim vTemp as string
    while not rs.eof
    'vTemp = rs' -->no good
    vTemp = Cstr(rs)' -->no good

    any ideas??
    -=-=-=-=-=-=-=-=-=-=-=-=-=-=
    *Morgan Cellular Technologies
    [email protected]
    -=-=-=-=-=-=-=-=-=-=-=-=-=-=

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482
    As you already know, Chris Eastwood's CodeGuru FTP Class
    at http://codeguru.earthweb.com/vb/articles/1852.shtml
    gives you a good start. Otherwise, this may help you on your way:
    Code:
    While (Not rs.EOF)
    ' granted it is overkill...
      Debug.Print rs(0)
      vTemp = rs(0)
      Debug.Print vTemp
      rs.MoveNext
    Wend

Posting Permissions

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



Click Here to Expand Forum to Full Width