[cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex

2011-09-07 Thread Mark Mandel
Sorry for the plug, but in case people aren't aware, we are running a competition for a current ANZ Student to win free flights, accommodation and a ticket to cf.Objective(ANZ) + Flex. Entry is a pretty simple 200 word entry, so nothing too crazy! Rules can be found here:

Re: [cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex [spamtrap bayes][spamtrap heur]

2011-09-07 Thread Richard Turner-Jones
Plugging at User Group meeting tonight http://www.baug.com.au Richard Mark Mandel mark.man...@gmail.com wrote: Sorry for the plug, but in case people aren't aware, we are running a competition for a current ANZ Student to win free flights, accommodation and a ticket to cf.Objective(ANZ) + Flex.

Re: [cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex

2011-09-07 Thread ColdGen Internet Solutions
Added to ACTCFUG: http://www.actcfug.com/index.cfm?actcfug=NewsViewNewsID=613 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

[cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Mike Kear
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 update a remote database, with the details of this event, then set a flag in the local record that the record has been exported to the remote database.

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Andrew Scott
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread ColdGen Internet Solutions
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,

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Andrew Scott
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Mike Kear
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?

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread christophe albrech
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Andrew Scott
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.

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread christophe albrech
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Mike Kear
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,

RE: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Andrew Scott
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 -Original Message- From: cfaussie@googlegroups.com

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Mike Kear
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Andrew Scott
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

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread Kai Koenig
+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

[cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Chong
I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different

[cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Steve Onnis
That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the

Re: [cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Barry Beattie
Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me:

[cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Steve Onnis
my disaster plan is an open ended ticket to mexico! :) kidding bi-daily backups etc The thing is even with all those backup plans it just adds more to the costs of running in a cloud. On Sep 8, 12:50 pm, Barry Beattie barry.beat...@gmail.com wrote: Steve: what's the Data Center's/your's

Re: [cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Blair McKenzie
As far as I can tell there are three main advantages of cloud infrastructure, and others have already mentioned most of them: 1) you don't have to manage your own hardware 2) pay by the hour - good for development, and ties into #3 3) you can bring up new instances effectively instantly - both

[cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Steve Onnis
Yes paying by the hour is great but when you are using them as production instances which need to be up 24/7 then the paying by the hour doesn't really come into it. On Sep 8, 3:35 pm, Blair McKenzie shi...@gmail.com wrote: As far as I can tell there are three main advantages of cloud

Re: [cfaussie] Re: Amazon EC2 hosting services viability

2011-09-07 Thread Paul Kukiel
Steve Take a look at Rackspace cloud options. I've been looking at them and chatting with Phil and they are also really good value for money and they don't loose your data like Amazon do upon restart. http://www.rackspace.com/cloud/ Paul. On Thu, Sep 8, 2011 at 3:56 PM, Steve Onnis