sorry, I meant to update that second update statement to false On Wed, Sep 7, 2011 at 10:23 PM, christophe albrech < christophe.albr...@gmail.com> wrote:
> Hi Mike, > > I won't comment about CF or any other database server, but this is possible > with SQL server. > > you need to create a link to your distant server first. Then in your > example, instead of using a cftransaction and 2 cfquery with different dsn, > you'd have something along the line of > > <cfquery dsn="local"> > being tran t1 > begin try > > INSERT into linkedserver.distantdatabase.dbo.table > values(...) > > > Update eventrecord > SET exportedToRemoteDB = true > > COMMIT > begin catch > > > Update eventrecord > SET exportedToRemoteDB = true > > end catch > end try > <cfquery> > > I'm sure ant modern dbms would have a similar mechanism, but I'm very much > a sql server fan boy, so it's the only thing I know ;-) > > as for actual cross-server transactions, you can configure something called > DTC (Distributed Transaction Coordinator). It's pretty much an engine that > allows a tran between 2 or more linked servers to be shared, and that > manages commits and rollbacks as a whole. > > hope this helps. > > Tof > > > On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott <andr...@andyscott.id.au>wrote: > >> I don't think ColdFusion cares about temp tables, as long as they exist at >> that time of the query. >> >> >> -- >> >> Regards, >> Andrew Scott >> WebSite: http://www.andyscott.id.au/ >> Google+: http://plus.google.com/108193156965451149543 >> >> >> >> On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions < >> coldgen.internet.soluti...@gmail.com> wrote: >> >>> 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 >>> >>> >>> >>> >> >> -- >> 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.