No idont think a temp table will solve the problem, which is bascially "how can i be sure that the remote database has updated, and if not, be sure of finding the correct records later when i try it again - without doubling up on records in teh remote database, or alternatively missing any?"
One way i could do it is to perform the remote insert, then immediately do a query on the remote database for that record, but i was hoping to do it without requiring another trip out to the remote database. Hence the question about 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 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 > > -- 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.