Ah, yes. If you're doing it that way, then you have to resort to stored procs that will insert your data with the trigger and return your stuff back to CF. Big PITA. Have fuuuunnnnn.
-d ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 11:14 AM Subject: RE: Access to Oracle > Hehe convince the State department that its better and I am all for it. > Unfortunately many of our intra and internet apps also have VB and Delphi > front ends that need to have the sequences. > > PITA > > Tim > > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 12:03 PM > To: CF-Community > Subject: Re: Access to Oracle > > > Hey Timothy, > There's an "Oracle Migration Workbench" that can be used to import Access to > Oracle. I don't know if it handles writing the triggers for you, but it's > pretty simple. > > Actually, I don't use triggers much anymore for auto-incrementing ids. The > reason is that it's not reliable to do the old "wrap 2 queries in a > cftransaction, insert your data, and pull the maxid" trick with oracle. > (There's an implicit commit between the 2 queries, even with the > cftransaction.) Instead, I do a cfquery where I pull the next value from a > sequence, then insert it as the new id with my other data. > > If I don't need the new id somewhere else on the page, you can just insert > the next value from a sequence (mysequence.nextval), which is even easier. > And, it means there aren't any triggers to maintain. > > -d > > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Community" <[EMAIL PROTECTED]> > Sent: Friday, February 14, 2003 10:28 AM > Subject: Access to Oracle > > > > Hi, > > Wondering if anyone knows an easy way to upsize an Access db to > Oracle? > > I mean, man is this looking like it's going to be a pain, triggers, and > > constraints and all will have to be totally written from scratch. What > kind > > of db doesn't have a field that doesn't auto-increment damnit. :) > > > > Timothy Heald > > Overseas Security Advisory Council > > U.S. Department of State > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
