in reply to Re: Updating a new column entry for CGI::Session 'sessions' table
in thread Updating a new column entry for CGI::Session 'sessions' table

I could try that suggestion. However, all my previous implementations were using interpolations and I had no problem. It just appeared that it's locking the session entry so that it can't be modified by an external process. I just have no idea if it's really such.Could MySQL lock a single row entry rather that the entire table?
  • Comment on Re: Re: Updating a new column entry for CGI::Session 'sessions' table

Replies are listed 'Best First'.
Re: Re: Re: Updating a new column entry for CGI::Session 'sessions' table
by astroboy (Chaplain) on Mar 25, 2004 at 16:48 UTC
    Are you testing for errors after your execute, or is RaiseError set for your database handle? Sorry, I don't know much about MySQL. If it was a locking problem, I'd either expect your SQL to hang until the lock was released, or return immediately because your update couldn't get a lock...