Field List

[Deltaflyer]

To access the database i am using :

oRecord.Open "Select * From Tbl",oConnect,3

is there any kind of oRecord.Index, that will return all the field names that have been included in the recordset. DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.

 

[froggerIII]

Use the Recordset.Fields object. Each field in the recordset is represented by a Field object in that collection, of which you can access the Name property.

You could probably do a for each loop through that collection, and pull out the name of the field each time through.

ray
rheindl@bju.edu

 

[Deltaflyer]

I shall give it a shot.

Cheers frogger. DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.

 

[Deltaflyer]

Frogger,

have tried that using the following code

ssql = "Select * from tbl_mas_pipeline"
oRecord.Open ssql, oConnect, 1
fieldlist = oRecord.Fields
Response.Write fieldlist &amp; &quot;<br>&quot;

this is the error i get,

Wrong number of arguments or invalid property assignment: 'fieldlist'

any ideas??

DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.

 

[Deltaflyer]

Sorry frogger, sorted it used the following.

for each oField in oRecord.fields
Response.Write &quot;<th>&quot; &amp; oField.name &amp; &quot;</th>&quot;
next

DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.

 

[froggerIII]

yep, the for each loop is the key when going through a collection ray
rheindl@bju.edu