when using oracle and cfinsert or cfupdate, you have to capitalize the Tablenames, otherwise it won't work--- i it's not recommendable to use cfinsert or cfupdate when the db is oracle, because they are about ten times slower then an cfquery tag with update and insert instructions (al least on CFAS 4.0) elmar -----Urspr�ngliche Nachricht----- Von: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 12. August 2000 18:45 An: '[EMAIL PROTECTED]' Betreff: <cfudate> and missing table Hello, Having trouble with <CFUPDATE>. The table being updated is not found in the datasource even though the data to be updated has just been extracted from that table. Database is Oracle 8 Tag is <cfupdate datasource="billygoat" tablename="main_table">. Any help? andy ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
