Forum OpenACS Q&A: Re: Re: how do you get locking transactions to work?

Collapse
3: Re: Re: how do you get locking transactions to work? (response to 2)
Posted by Claudio Pasolini on 06/01/06 08:28 AM
In the past I noticed that doing any db_dml within a db_foreach doesn't work as a transaction, because they use a different handle.

If this is the case simply get your rows with a db_list_of_lists and then loop over them with a foreach.

Collapse
5: Re: Re: Re: how do you get locking transactions to work? (response to 3)
Posted by Malte Sussdorff on 06/01/06 10:40 AM
Claudio, would you mind if you add this comment to the db_dml or db_foreach procedure definition / api documentation? This is a valuable piece of information that should get in there.