Re: Re: Updating a new column entry for CGI::Session 'sessions' table

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...	[reply]

In Section Seekers of Perl Wisdom