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.
