Forum OpenACS Development: Re: db_transaction hanging a thread how to detect, how to kill...

Collapse
4: Re: db_transaction hanging a thread how to detect, how to kill... (response to 1)
Posted by Jade Rubick on 09/19/03 03:17 AM
Jerry, you're not a loyal reader of my blog, are you? :-)

You shouldn't have db_dml statements inside a db_foreach or vice versa. Here's how to get around it:

http://rubick.com:8002/blogger/one-entry?entry%5fid=1643

Of course, the problem I have with that sometimes is that db_list and db_list_of_lists do not guarantee the order of the lists. So sorting gets screwed up.

So then you have to sort it. Ug.