ok, so I can modify the file reactor/xsl/dao.project.xsl adding in a wee bit to the section controlling creation of the DAOs update method. Works for me, but for the rest of the world that doesn't use Oracle I dunno. Maybe everyone should just use Oracle? ha!! Old Steve would like that , eh?
I thought about whether this is a good thing or not too. Would it be better to in this sort of case, not create a update? Or maybe its better to maek the update() method actually perform a delete() then a create()? I know Doug is out and all, and he better stay away, eh? I've never really gotten involved with this sort of thing. How to contribute here? DK On 5/19/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
yes, this is known. Its because Oracle stores all its table metadata using upper case. Not the issue with the below though. DK On 5/19/06, wikiwikiman <[EMAIL PROTECTED]> wrote: > 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/ > > > -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it?
-- 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/
