CFDBINFO doesn't see a table that does exist

[WolfShade]

Hello, all,

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?

V/r,

^_^

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.

[haxtbh]

What type of SQL server?

[WolfShade]

Och.. I should have included that information.. SMH..

Oracle 11g database.

V/r,

^_^

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.

[WolfShade]

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?

V/r,

^_^

[haxtbh]

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" /> 

[WolfShade]

Same thing:  table "F\_COMMENTS" does not exist.

V/r,

^_^

[haxtbh]

WHat version of Coldfusion?

[WolfShade]

CF10 running on Windows 2008 Server.

V/r,

^_^

[WolfShade]

I've added a bug to the bugbase, just in case.

Bug#4126114 - CFDBINFO type="columns" claims table does not exist in an Oracle 11g db if table name ...

V/r,

^_^