ColdFusion 9 or 9.01, I think added this, not 100% certain on it though.
On Wed, Sep 7, 2011 at 9:23 PM, Mike Kear afpwebwo...@gmail.com wrote:
The scenario:
I have a local application, which updates a local database as a
business process goes on.But I want the application also to
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,
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
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?
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
Mike,
You don't say which version of ColdFusion your using either.
btw
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c6b.html
On Wed, Sep 7, 2011 at 10:22 PM, Chris Velevitch
chris.velevi...@gmail.comwrote:
I think the solution is a message queue.
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
Sorry Andrew, you're quite right - i forgot to say it's CF9.0.1.
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:24 PM,
@googlegroups.com] On Behalf
Of Mike Kear
Sent: Wednesday, 7 September 2011 10:31 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Sorry Andrew, you're quite right - i forgot to say it's CF9.0.1.
Cheers
Mike Kear
Windsor, NSW, Australia
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
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
+1 - A message queue is the best solution for this type of problem.
Cheers
Kai
I think the solution is a message queue. It's a system that guarantees
the message (record) is delivered to the other system (database) and
it can give that guarantee because it stores all the messages in it's
12 matches
Mail list logo