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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
