|
|
Posted by Rik on 04/25/07 22:07
Giovanni wrote:
> Hi people!
> I was writing a function in which I execute a query to READ some
> value, and another one to UPDATE the previous query related data.
>
> i.e.
> query-> select * from ..... to retrieve myvalue
> read myvalue
> change myvalue
> query-> update myvalue
>
> Suddenly I had a doubt...
> Can 2 or more browsers call the same function at "same time" and start
> the UPDATE query with some still uncomputed data? or is the function
> synchronized?
Well, 'uncomputed data', no... They can overwrite each others changes
though. Most of my systems aren't that busy, so I opt for:
UPDATE table SET field1=..., field2=... WHERE field1=..., field2=...
If there's no row updated, report the record has been changed, and ask
the user again...
--
Rik Wasmus
Estimated date being able to walk again: 01-05-2007.
Less then a week, hurray!
Navigation:
[Reply to this message]
|