This is a simple enough test case, but it simply doesn't work. I have tried it
w/ & w/o action="#cgi.script_name#" & format="flash". I have made ALL of the
field names upper case. The grid populates just fine.

Error message:
There are no columns found for the given table name "ADAPPSTST.INV_TESTA".
This error may be caused by not specifying the table name in the format that
the database server expects. (For example. Oracle Server table name must be
upper case or the Server table name must be qualified in the format of
"schema.table_name". For the SQL Server, the format is
"databasename.username.tablename", such as in customers.dbo.orders)
The error occurred on line 13.

CFDUMP:
Generated Content:
struct
FIELDNAMES GRIDENTERED,__CFGRID__GRIDTEST__FIRSTGRID
FIRSTGRID.AID array1 6
FIRSTGRID.ANAME array1 F
FIRSTGRID.ORIGINAL.AID array1 [empty string]
FIRSTGRID.ORIGINAL.ANAME array1 [empty string]
FIRSTGRID.ROWSTATUS.ACTION array1 I
GRIDENTERED [empty string]
__CFGRID__GRIDTEST__FIRSTGRID __CFGRID__EDIT__=2AIDYANAMEY1I6F

Thanks

Mike

<cfif IsDefined("form.gridEntered") is true>
<cfdump var="#form#">
<cfgridupdate grid="FIRSTGRID"
dataSource="#APPLICATION.FACILITYDSN#"
keyonly="yes"
tableName="ADAPPSTST.INV_TESTA">
</cfif>
<!--- Query the database to fill up the grid. --->
<cfquery name="QTABLEA" datasource="#APPLICATION.FACILITYDSN#">
SELECT AID, ANAME
FROM ADAPPSTST.INV_TESTA
ORDER BY ANAME
</cfquery>
<h3>cfgrid Example</h3>
<I>Try adding a course to the database, and then deleting it.</i>
<cfform name="GridTest" action="#cgi.script_name#" format="flash">
<cfgrid name = "FIRSTGRID" width = "450" query = "QTABLEA" insert = "Yes"
delete = "Yes"
font = "Tahoma" rowHeaders = "No" colHeaderBold = "Yes" selectMode =
"EDIT"
insertButton = "Insert a Row" deleteButton = "Delete selected row">
<cfgridcolumn name="AID" header="AID">
<cfgridcolumn name="ANAME" header="ANAME">
</cfgrid>
<cfinput type="submit" name="gridEntered">
</cfform>