On 2008-02-20 17:19, breal wrote:
> On Feb 20, 8:05 am, "M.-A. Lemburg" <[EMAIL PROTECTED]> wrote:
>> On 2008-02-20 16:24, breal wrote:
>>
>>> I have a db table that holds a list of ports. There is a column
>>> in_use that is used as a flag for whether the port is currently in
>>> use. When choos
breal wrote:
> Thanks for the reply. I understand that this is normal locking
> behavior. What I am looking for is a standard method to either loop
> the query until the table is unlocked, or put the query into some sort
> of queue. Basically my queries work like this.
>
> Request comes in
>
breal wrote:
> On Feb 20, 8:05 am, "M.-A. Lemburg" <[EMAIL PROTECTED]> wrote:
>> On 2008-02-20 16:24, breal wrote:
>>
>>> I have a db table that holds a list of ports. There is a column
>>> in_use that is used as a flag for whether the port is currently in
>>> use. When choosing a port the table
On Feb 20, 8:05 am, "M.-A. Lemburg" <[EMAIL PROTECTED]> wrote:
> On 2008-02-20 16:24, breal wrote:
>
> > I have a db table that holds a list of ports. There is a column
> > in_use that is used as a flag for whether the port is currently in
> > use. When choosing a port the table is read and the f
On 2008-02-20 16:24, breal wrote:
> I have a db table that holds a list of ports. There is a column
> in_use that is used as a flag for whether the port is currently in
> use. When choosing a port the table is read and the first available
> port with in_use = 0 is used, updated to in_use = 1, use
I have a db table that holds a list of ports. There is a column
in_use that is used as a flag for whether the port is currently in
use. When choosing a port the table is read and the first available
port with in_use = 0 is used, updated to in_use = 1, used, then
updated to in_use = 0. I am using