Link to home
Start Free TrialLog in
Avatar of dolomite
dolomite

asked on

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?
Avatar of dlewis9
dlewis9

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

Nathans
ColdFusion Tips Plus
www.nsnd.com
ASKER CERTIFIED SOLUTION
Avatar of Dain_Anderson
Dain_Anderson

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dolomite

ASKER

Thanks, that did the trick.  The code works like a champ now.