Is a big ask - what about a temporary table or backup table you can flag for records that made it through - you can compare commits to?
I have a similar issue but for sending emails AND the database issue. Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 On 7 September 2011 21:36, Andrew Scott <andr...@andyscott.id.au> wrote: > ColdFusion 9 or 9.01, I think added this, not 100% certain on it though. > > > On Wed, Sep 7, 2011 at 9:23 PM, Mike Kear <afpwebwo...@gmail.com> wrote: >> >> The scenario: >> >> I have a local application, which updates a local database as a >> business process goes on. But I want the application also to update >> a remote database, with the details of this event, then set a flag in >> the local record that the record has been exported to the remote >> database. However I'm building error handling to provide for the >> possibility that the remote database might not be available. I dont >> want that to stop the local application, or it will close the business >> down. I want the business to go on, the customer satisfied and >> the web site can be updated later on when the internet connection is >> back up again >> >> Does CFTRANSACTION handle the commit/rollback of both databases if any >> part of the queries fails? I would code it kind of like this: >> >> <cftransaction> >> <cfquery name="qRemoteInsert" datasource="remoteDSN"> >> INSERT into eventrecord yada yada yada >> </cfquery> >> <cfquery name="qlocalUpdate" datasource="localDSN"> >> Update eventrecord >> SET exportedToRemoteDB = true >> WHERE eventID = <cfqueryparam value="#thiseventID#" >> cfsqltype="cf_sql_integer"/> >> </cfquery> >> </cftransaction> >> >> -- >> Cheers >> Mike Kear >> Windsor, NSW, Australia >> Adobe Certified Advanced ColdFusion Developer >> AFP Webworks >> http://afpwebworks.com >> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month >> >> -- >> You received this message because you are subscribed to the Google Groups >> "cfaussie" group. >> To post to this group, send email to cfaussie@googlegroups.com. >> To unsubscribe from this group, send email to >> cfaussie+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/cfaussie?hl=en. >> > > > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/108193156965451149543 > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.