Skip to main content
WolfShade
Legend
March 8, 2016
質問

CFDBINFO doesn't see a table that does exist

  • March 8, 2016
  • 返信数 3.
  • 741 ビュー

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.

    このトピックへの返信は締め切られました。

    返信数 3

    WolfShade
    WolfShade作成者
    Legend
    March 8, 2016
    WolfShade
    WolfShade作成者
    Legend
    March 8, 2016

    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,

    ^_^

    Inspiring
    March 8, 2016

    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
    WolfShade作成者
    Legend
    March 8, 2016

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

    V/r,

    ^_^

    Inspiring
    March 8, 2016

    What type of SQL server?

    WolfShade
    WolfShade作成者
    Legend
    March 8, 2016

    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.