Jeff Amiel wrote:
> Add a column to the nameq table designating the 'state' of the image.
> Then your logic changes to "select * from nameq where serial = (select
> min(serial) from nameq) and state="UNPROCESSED" (or whatever)
> So you select for update, change the state, then process the
> image....then delete.
Thanks Jeff, I think that will work perfectly for me!
Cheers,
Mark
--
Mark Harrison
Pixar Animation Studios