mariusp..
As far as i can make out, ur trying to retrieve ALL of the coloumns and rows in the recordset or are you trying to retrieve just the Coloumn name?? Or are you trying to retrieve the SCHEME of a table?? If u look at OGUNNIKES poste, the code he uses is right as is the post regarding the SCHEME.
the error message is stating that it cannot create a connection to an server object using the creatobject method, which is trying to create an instance of a component, the field.. If i am not mistaken (i havent really had to use the field collection) u can access the fields collection without having to specify a recordset (in the ADO model , the field & fields collection is part of the recordset object, with the connection object at the top of model. So i would assume that you at least need to create a connection object first (i assume that you have done this) then you can use the fields collection to retrieve the coloumn name.. (Have a feeling some one is going to say i am wrong)
Anyhows i would try:
Create a recordset & a connection to ur data store
open the recordset etc etc
then
strO = "" ' Use the strO to start building a table
For each fld in objR.Fields
strO = strO & "<td> & fld.Name & "</td>"
Next
close table, close connection/recordset blah blah
Response.write StrO
Hope this helps
I think it would be better if u posted all the code to see whats going on.
DJWright
|
