Getstring method ?

Results 1 to 2 of 2

Thread: Getstring method ?

  1. #1
    Join Date
    Dec 1969

    Default Getstring method ?

    Has anybody worked with getstring method of a recordset(ADOs)? It doesn&#039t give me any data though the data is available in the recordset.<BR>Is there any other method for getting all the data from recordset into a string? I , basically, want to write it to a textfile. Putting all the data in the recordset in a session variable may be one way !! ?? How bad is this ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Getstring method ?

    You could also just Loop through the recordset just as you would to display it on screen.<BR><BR>Do while Not rst.EOF<BR> strVariable = rst("field1") & "," & rst("field2") & "," ...<BR> fso.WriteLine strVariable<BR> rst.MoveNext<BR>Loop<BR><BR>HTH<BR><BR>Jerry<BR>

Posting Permissions

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