• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

CF Grid error with oracle

I used the example code that came w/CF Studio 4.5 using the access database w/cfsnippet datasource.  Yet when i replace the query & datasource with an oracle one (were using the oracle 7.3 native driver) along with the changes to the grid columns. It loads the applet up just fine but when u try to update it i come back with the error:

The table 'auction_fut' contained no columns in the grid 'cforacle'.

This error may have been caused by not specifying the table name in the format which the ODBC data source expects (e.g. SQL Server table names must be qualified with the database name and table owner, as in 'customers.dbo.orders').

Not sure what this means? Any suggestions?
1 Solution
Can you post your code?  I think I found the example you are referencing, but it will help to see your modifications...

The error message suggests that perhaps you need to preface your table name with the table owner on the CFGRIDUPDATE and possibly in the CFQUERY...sounds like they're not matching somewhere..it's pretty picky.  If you can post debug info, that may help too because you can see the Form variables that the CFGRID creates.
I have a feeling you may have to manually update instead of using the CFGRIDUPDATE

ColdFusion Tips Plus
First off, make sure you have Oracle version or better; otherwise, it may not work. Also, make sure your default database name in your datasource is set correctly -- if not, you are connecting to the wrong one.
You can override this by using the DBNAME attribute. Since this is Oracle, your TABLENAME attribute's value must be in uppercase letters. It might be wise to use the TABLEQUALIFIER attribute to specify which database holds the table specified in TABLENAME.
It sounds like you need to uppercase the table name and add the TABLEOWNER attribute -- this will add the owner before the database objects.

In Oracle, it should look like this:


Hope that helps
dolomiteAuthor Commented:
Thanks, that did the trick.  The code works like a champ now.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now