Did you delete all of your project files? On 2/26/07, Bryan S <[EMAIL PROTECTED]> wrote:
BethO.K. I tried it now and can report that it does not work. After reviewing the code I understand why not. This is the function that checks if sequences are supported in reactor\data\oracle\Convention.cfc <cffunction name="supportsSequences" access="public" hint="I indicate if the DB support sequences" output="false" returntype="any" _returntype="boolean"> <cfreturn true /> </cffunction> So basically if I am using Oracle the code below is going to run and increment it by two instead of one. For now I guess I will have to comment out the block of code that creates that section in dao.project.xsl. Unless someone has a better idea. Bryan On 2/23/07, Beth Bowden <[EMAIL PROTECTED] > wrote: > 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. > > > > In my TABLE_NAMEDao.cfc the create function has the code below in it. If I > > comment this block of code out the problem stops. qCreate returns a key > > field that is correctly incremented by one. However, when the record is > > inserted the key field jumps an additional one because of my trigger. > > > > It seems that Reactor is recognizing that Oracle supports sequences but not > > that I have a trigger so it doesn't have to increment it for me. > > > > How do I tell Reactor that I'm handling this? > > > > <cfif Convention.supportsSequences()> > > > > <cfquery name="qCreate" > > datasource="#_getConfig().getDsn()#" > > username="#_getConfig().getUsername()#" > > password="#_getConfig().getPassword()#"> > > > > #Convention.getNextSequenceSyntax("S_DEV_PLATFORM")# > > </cfquery> > > <cfset > > arguments.to.DVP_APP_PLATFORM_ID = qCreate.ID /> > > > > </cfif> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
