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.