Beth I have the same situation for every table in my database. Every table has a auto increment primary key. Seems like their should be some kind of global setting.
Bryan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Beth Bowden > Sent: Friday, February 23, 2007 4:20 PM > To: [email protected] > Subject: Re: [Reactor for CF] Oracle Auto Increment Key moves by two > > Bryan, > > Off the top of my head, I suggest removing the line in the > config file that specifies a sequence for that table. > > HTH > > Beth > > On 2/23/07, Bryan S <[EMAIL PROTECTED]> wrote: > > Using Oracle. > > > > I have a sequence set up on the ID fields on my tables. I have a > > trigger that increments the sequences automatically when a > record is > > entered. This works fine in a DB administrator. When I add a record > > using reactor the key increments by two. I figured out why > but I need > > to know the best way to work around this... assuming it isn't a bug. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
