Re: [CDBI] Inconsistent reads from database when using web interface

On Thu, Aug 28, 2008 at 6:01 PM, Carlos Vicente
<cvicente-zZ82ZiX1S8l+u43qRgrggVnYRNhDb3e+9nwVQlTi/[email protected]> wrote:
> However, after following their directions (setting
> |transaction-isolation to READ-COMMITTED|, it is still happening.

It does sound like the problem you're having.  Can you verify the
setting by checking it in the code with the same $dbh you read the
data with right before you print it?  Do you run with autocommit on?

It's also possible you might be storing data in closure variables or
globals.  Can you do some debugging to figure out if the data is being
read from the database or not?  DBI_TRACE can help there, or you can
add some straight SQL selects and print the values to the error_log
and compare them with what you see in the HTML.

- Perrin