I need to pull a bunch of name/value pairs from a recordset and write them to a flat file. I have everything working so far except I don't know how to turn the For Each loop into a string variable that I can write to the flat file. Below is the code I have that will write the information in the correct format to an asp page. Please help me turn it into a string.

For Each ofield in oRSNB.fields
  strField = ofield.name
  strValue = oRSNB.(strField)
  Response.Write strField & "=" & strValue & "|"
Next

hi there,
to do that you must in first write sql enqiery that can read all the recordset :

set ors = server.createobject("adodb.recordset")
Ssql = "SELECT * FROM XXXX "
ors.open Ssql,Application ("conn1"),adopenstatic,adcmdtable

and then make this loop to output all recrdset :

while not ors.eof
  .
  .
  .
 ors.movenext
wend

Reg



ali

Thanks much
Dale

Once you have your SQL query returning the two columns you want, there is a really easy way to create a string out of the whole set of data with a single call to the recordset:

<recordset>.GetString(, , "=", "|", "")

The arguments are:
StringFormat (you can leave that empty)
NumRows (again, leave empty or -1 for all rows)
ColumnDelimiter
RowDelimeter
NullExpr (value to use for Null values, usually "")

The recordset handles all the looping of its data and will give you a completed string with all the data in the format you want.

Peter
------------------------------------------------------
Work smarter, not harder.