re: case issue - yup, was looking at the core reactor code on that. Its in those queries hitting the Oracle Data Dictionary. An amazing piece all that code too!
re: the issue in this thread originally- I'll attach the modifed dao.project.xsl after I test it some more Munday. Basically I just added a check: if no non-primary key fields exists, spit out all primary key fields in the update statements SET clause. So far its working. But I work in a all Oracle shop, so don't know the effects something like this would have on other DBs. peas DK On 5/19/06, Bowden, Beth (NIH/NIEHS) [E] <[EMAIL PROTECTED]> wrote:
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/
-- 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/
