Retrieving colum values from record by index.

[rabisco]

I think I have just about tied myself up in knots on this one.
Here goes

for each c in arrCols
Response.Write ("Columns to retrieve from spreadsheet")
Response.Write("<br>")
Response.Write c
Response.Write("<br>")
'Response.Write rs.fields.item(c).value
On Error Resume Next
Next

The code gets an index from a couple of arrays, I now want use the index to retrieve the value of a column(wih the same index) from a recordset.
I'll appreciate your help as usual.

 

[rabisco]

By the way, I am able to get the coumn name with

Response.Write rs.fields.item(c).name,

but I get an error with

Response.Write rs.fields.item(c).value

 

[PHV]

but I get an error
Any chance you could post the error message ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886