Doug, Table and column names are stored in Oracle system tables in uppercase. If the names are lowercased (or mixed case), the selects won't find the entries in the system tables. A simple uppercase will fix the problem. Beth
________________________________ From: Doug Hughes [mailto:[EMAIL PROTECTED] Sent: Fri 5/19/2006 8:38 PM To: [email protected] Subject: RE: [Reactor For CF] interesting outcome >From my (limited) experience with oracle it doesn't require uppercase fields. They can be in either case. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of wikiwikiman Sent: Friday, May 19, 2006 11:55 AM To: [email protected] Subject: Re: [Reactor For CF] interesting outcome Since you're using Oracle, you had better make sure that all table and field names are uppercased (that's what Oracle reuires). If I'm not mistaken, the latest version of Reactor may well have a bug in this matter - try uppercasing your names in the reactor.xml file and try again... Wouter On 5/19/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > I have a table called mytable say with two columns fkone and fktwo. > This table is a so called link table and both columns comprise the > primary key. I'm using Oracle BTW. Looking at the DAO for this table > generated by reactor I see SQL like this > > UPDATE mytable > SET > WHERE > fkone = ... > AND > fktwo = .... > > obviously this bombs out when I try to perform a save() on the mytable > object. Am I breaking a best practise here? Or is this a bug of some > sort? > > -- > Douglas Knudsen > http://www.cubicleman.com > this is my signature, like it? > > > > -- Reactor for ColdFusion Mailing List -- [email protected] > -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ > > > -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
