Re: unlock rows

On Thu, Mar 13, 2003 at 10:58:57 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> What about if one is using a row as a semaphore?
>
> For example, a script accessing the database needs to know if a certain table has any rows in it
> with 'appoved::bool' equal to false before it inserts a row that WILL have that set to false.
> that way, it will generate an email to the site owner to go and look at items in that table and
> approve them.
>
> I wouldn't want an email for each line added.

When you do the query to see who to email you can should have it combine
all of the items for a given site into one message.