RE: SOT: CF based Message Queue - Thread safe stored procedure

2009-06-26 Thread Bobby Hartsfield
in for the help. .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, June 25, 2009 9:22 PM To: cf-talk Subject: RE: SOT: CF based Message Queue - Thread safe stored procedur

RE: SOT: CF based Message Queue - Thread safe stored procedure

2009-06-25 Thread Bobby Hartsfield
where queue.messages.messageID = .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Thursday, June 25, 2009 6:09 PM To: cf-talk Subject: Re: SOT: CF based Message Queue - Thread safe stored proc

Re: SOT: CF based Message Queue - Thread safe stored procedure

2009-06-25 Thread Jochem van Dieten
On Thu, Jun 25, 2009 at 9:52 PM, Will Tomlinsonwrote: > The whole flow of the Stored Procedure needs to be something like this... > > 1) Grab the next message record where the status is 'pending' > 2) Update that record's status to 'running' > 3) Return the record > > While that is running, no oth

SOT: CF based Message Queue - Thread safe stored procedure

2009-06-25 Thread Will Tomlinson
Hi all, I have an issue with a stored proc that hopefully someone can help with... A little background... I built a CF based message queue system. It is pretty simple; I have a table of 'messages' in the database. I can fire up as many infinite threads as I want and they process those message