I'm migrating a CF 4/Oracle 8 application that uses <cfinsert> and <cfupdate> tags to CFMX 7.0.2 and Oracle 10g.
The tags are erroring on the table name property. The way this database access is set up I must prefix the table name with the schema name in order to access the data. When I use SCHEMA.TABLE_NAME, both tags error on the table name. Does anyone know of specific issues between CFMX 7 and Oracle 10g? The tags are used in third party custom tags that generate dynamic forms and therefore don't want to change to <cfquery>. CF Exception Text: 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) There are no columns found for the given table name: "SCHEMA.TABLE_NAME" Shelley Browning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
