sql query not returning correct results

[yawnmoth]

i'm using an entry in an sql database as a semaphore and it,
unfortunately, doesn't appear to be working. the script that spawns
the child processes has a for loop that performs the same basic sql
query over and over again until the value has changed (there's a one
second delay between each query). unfortunately, the resultant row is
always the same, even when the other process *has* changed it. as an
example, if the orig. value was of the entry was 0, and one second into
the execution of the second process, the entry was changed to 1, my
program would, even 10 seconds later, fetch 0. in other words, it'd
never be aware of the change.

any idea as to why this is and what i can do to fix it? thanks!

[Malcolm Dew-Jones]

yawnmoth (te*******@yahoo.com) wrote:
: i'm using an entry in an sql database as a semaphore and it,
: unfortunately, doesn't appear to be working. the script that spawns
: the child processes has a for loop that performs the same basic sql
: query over and over again until the value has changed (there's a one
: second delay between each query). unfortunately, the resultant row is
: always the same, even when the other process *has* changed it. as an
: example, if the orig. value was of the entry was 0, and one second into
: the execution of the second process, the entry was changed to 1, my
: program would, even 10 seconds later, fetch 0. in other words, it'd
: never be aware of the change.

: any idea as to why this is and what i can do to fix it? thanks!

Perhaps the other process hasn't committed the changes?

--

This space not for rent.

[TerraFrost]

Malcolm Dew-Jones wrote:

yawnmoth (te*******@yahoo.com) wrote:
: i'm using an entry in an sql database as a semaphore and it,
: unfortunately, doesn't appear to be working. the script that spawns : the child processes has a for loop that performs the same basic sql
: query over and over again until the value has changed (there's a one : second delay between each query). unfortunately, the resultant row is : always the same, even when the other process *has* changed it. as an : example, if the orig. value was of the entry was 0, and one second into : the execution of the second process, the entry was changed to 1, my
: program would, even 10 seconds later, fetch 0. in other words, it'd : never be aware of the change.

: any idea as to why this is and what i can do to fix it? thanks!

Perhaps the other process hasn't committed the changes?

I guess a syntax error could result changes not being committed, heh.
'cause that's what the problem turned out to be. Thanks for the
suggestion! :)