Thanks, Rex and Mary Jo... I figured the call would be something rather obvious, but didn't want to make any assumptions without getting input.
This will be my *first* opportunity to work with a stored procedure. Well, not opportunity, but situation where it's really called for. I'll do some digging in the MySQL 5 docs on that and see what I can do. Thanks, again! Rick > -----Original Message----- > From: rex [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 25, 2008 12:12 AM > To: CF-Talk > Subject: Re: Best way to cause scheduled tasks to run consecutively? > > Since a CF Scheduled task is basically just a call to a webpage, just > put a <CFLOCATION> in your code. > > So, your scheduled task will be calling task1.cfm, and the last part of > your code would be a <CFLOCATION URL=" task2.cfm" /> > > If you are only doing queries, the best way to do it would be on the SQL > side. A stored procedure as a SQL job would be the way to go. That > way, you can wrap everything around a transaction and rollback when it > breaks. It'll be faster, plus if you use a CF Scheduled Task, you will > be breaking out your queries and you cannot do CFTRANSACTIONs. > > And, yes, even though you can still do regular transactions, bear in > mind that if your CF errors out with open transactions you will run into > locking issues. Doing this on the database side is the best way to > approach this. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
