Ask a Question related to ASP Database, Design and Development.
-
Scotter #1
ASP/Access2002: how do I get column names from table (in order) using OLE DB?
When I use ADOX to get columns(fields) of a table, they are auto-sorted
alphabetically by name.
I need to get the list of field names as they appear when I open the MDB
file and view details of the table.
I tried using open schema with following code causing this error msg: "Item
cannot be found in the collection corresponding to the requested name or
ordinal"
Set rsSchema = conn.OpenSchema(4, Array(Empty, Empty, "config"))
rsSchema.Sort = "ORDINAL_POSITION"
Thanks!
--
Scotter
Scotter Guest
-
Pulling table column names
How can I pull table column names? I would like to put then in menu / cfselect statment. Thanks, Matthew -
counting column and getting column names
Im using an Access database that will probably be switched over to Oracle later, but I need to find out how to get the number of columns in an... -
querying field / column names in Access table
I got great info on my last post, so let's try this one and see if my luck is still good: I have an Access table with about 30+ columns / fields... -
ASP/Access 2002: how do I get column names from table (in order) using OLE DB?
When I use ADOX to get columns(fields) of a table, they are *auto-sorted alphabetically by name*. I need to get the list of field names as they... -
asp get Table Column ( Show Active Users Names Logged On )
Hello; I know how to get a "Database Table" with ASP. But what I am trying to get is the Table Column. This is what I am needing. ( Could... -
[MSFT] #2 RE: ASP/Access2002: how do I get column names from table (in order) using OLE DB?
Hi Scotter,
Please refer to my answer in another post with same subject.
Luke
[MSFT] Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
