We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.
I'm trying to troubleshoot an issue with the DBINFO tag, and I've never used it, before.
Basically, we have a schema ("FC") that has many tables, one of which is called "F_COMMENTS". In CFAdmin, the DSN is named the same as the schema.
I'm using the following:
<cfdbinfo type="columns" table="F_COMMENTS" datasource="FC" name="dbdata" />
The error message states that table F_COMMENTS doesn't exist. But it does.
What could be causing this erroneous message?
UPDATE: I did the following:
<cfdbinfo type="tables" datasource="FC" name="dbdata" />
The CFDUMP of that does show that the table "F_COMMENTS" is in the datasource.
What type of SQL server?
Och.. I should have included that information.. SMH..
Oracle 11g database.
UPDATE: Oh, and I tried another DSN and table, and I'm getting the same error.
type="dbnames" and type="tables" both work with no issues. However, whenever I try to use type="columns", suddenly the table (that appears in type="tables") doesn't exist.
Made an odd discovery.
If an underscore is part of a table name, the described error happens. If there is NOT an underscore in the table name, it works just fine.
Is this a bug?
I tested your example with MS SQL and had no problems. Both with and without an underscore.
What happens when you escape the underscore? So something like this:
<cfdbinfo type="columns" table="F\_COMMENTS" datasource="FC" name="dbdata" />
Same thing: table "F\_COMMENTS" does not exist.
WHat version of Coldfusion?
CF10 running on Windows 2008 Server.