Mike, I reread the documentation it looks like the across multiple databases is in fact an enterprise only feature, surprise surprise...
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Thu, Sep 8, 2011 at 12:05 AM, Mike Kear <afpwebwo...@gmail.com> wrote: > Ok i have the answer - "NO". For those who are just tuning in, I > asked whether i could wrap two queries on different datasources with > CFTRANSACTION tags, and in CF9.0.1 I get an error message saying that > the datasource for all queries inside CFTRANSACTION tags must be the > same. > > So i think i am going to have to do the insert on the remote > datasource, then do a query on the same datasource to verify it has > happened correctly, unless someone has a better idea. The most > likely problem I foresee is that the internet might be down for one > reason or another during a transaction. In that case, I want the > local processing to continue without a pause, and the remote database > updated later on when the internet is up again, and be able to ensure > [a] no duplicate records are inserted on the remote database, and [b] > no records are missed either. > > Anyone have a better idea? > > 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 > > > > On Wed, Sep 7, 2011 at 10:28 PM, Andrew Scott <andr...@andyscott.id.au> > wrote: > > That’s ok Mike, I would assume that unless otherwise stated. So the > answer > > is yes to your question. > > > > -- > > 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.