• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

CFDBINFO doesn't see a table that does exist

LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

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.

Views

433

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

What type of SQL server?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

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,

^_^

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

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

V/r,

^_^

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

WHat version of Coldfusion?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

CF10 running on Windows 2008 Server.

V/r,

^_^

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 08, 2016 Mar 08, 2016

Copy link to clipboard

Copied

LATEST

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation