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.