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.