Highlighted

CFDBINFO doesn't see a table that does exist

LEGEND ,
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

286

Likes

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

CFDBINFO doesn't see a table that does exist

LEGEND ,
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

287

Likes

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
Mar 08, 2016 0
Advocate ,
Mar 08, 2016

Copy link to clipboard

Copied

What type of SQL server?

Likes

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
Reply
Loading...
Mar 08, 2016 0
LEGEND ,
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.

Likes

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
Reply
Loading...
Mar 08, 2016 0
LEGEND ,
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,

^_^

Likes

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
Reply
Loading...
Mar 08, 2016 0
Advocate ,
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" /> 

Likes

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
Reply
Loading...
Mar 08, 2016 0
LEGEND ,
Mar 08, 2016

Copy link to clipboard

Copied

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

V/r,

^_^

Likes

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
Reply
Loading...
Mar 08, 2016 0
Advocate ,
Mar 08, 2016

Copy link to clipboard

Copied

WHat version of Coldfusion?

Likes

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
Reply
Loading...
Mar 08, 2016 0
LEGEND ,
Mar 08, 2016

Copy link to clipboard

Copied

CF10 running on Windows 2008 Server.

V/r,

^_^

Likes

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
Reply
Loading...
Mar 08, 2016 0
LEGEND ,
Mar 08, 2016

Copy link to clipboard

Copied

Likes

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
Reply
Loading...
Mar 08, 2016 0