>
> Sorry, I am using MySQL.
>
> It does support FOR UPDATE, but would that still return the array reference?
>
> Thanks
> zack
>
> ----- Original Message -----
> From: "Michael A Chase" <[EMAIL PROTECTED]>
> To: "Zachary Buckholz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, May 20, 2002 9:23 PM
> Subject: Re: REQ: help running select and update based on results
>
>
> > On Mon, 20 May 2002 21:02:53 -0700 Zachary Buckholz
> <[EMAIL PROTECTED]> wrote:
> >
> > > I have two subs in my program one, selects a list of urls to work on and
> > > then the next sub updates the selected url's because I am running fork
> and
> > > don't want another process to check out the same url's thus causing
> things
> > > to go crazy.
> > >
> > > But my problem is that while this was good intentioned, it's not quick
> > > enough. By the time one sub has checked out the url's and the next sub
> has
> > > updated them to try and prevent them from being checked out again
> another
> > > child process has already run the first select query and gotten the same
> > > list of URLs.
> > >
> > > So how can I add the update to the initial select?
> >
> > In some RDBMS you can SELECT ... FOR UPDATE, but since you didn't mention
> > what one you are using, I can't say if yours allows that.
> >
> > --
> > Mac :})
> > ** I normally forward private questions to the appropriate mail list. **
> > Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
> > Give a hobbit a fish and he eats fish for a day.
> > Give a hobbit a ring and he eats fish for an age.
> >
>
