Ask a Question related to Coldfusion Database Access, Design and Development.
-
Matthew #1
Pulling table column names
How can I pull table column names? I would like to put then in menu / cfselect statment.
Thanks,
Matthew
Matthew Guest
-
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/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... -
HELP! - Need SQL code for pulling table name
I am having trouble finding the SQL to pull the table name to precede the fld.Name since I am pulling from two different tables. Any ideas?? ... -
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... -
eastinq #2 Re: Pulling table column names
You can get a list of columns from <cfquery>. Use the following SQL example to
get empty record set back with column names.
<cfquery name="myqry" datasource="testdb">
select * from table_a where 1 = 0;
</cfquery>
<cfoutput>
#myqry.columnList#
</cfoutput>
eastinq 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
