Re: [SQLObject] More transaction troubles

[Randall R. <ra...@ra...>]

On Saturday, September 6, 2003, at 08:37 AM, Sidnei da Silva wrote:

> On Sat, Sep 06, 2003 at 04:58:49AM -0400, Randall Randall wrote:
> | >>> r.firstName = 'Billy'
> | >>> trans.rollback()
> | >>> print r.firstName
> | Billy
>
> A wild guess: rollback() isn't clearing the cache.

Just to clarify, I did have
_cacheValue = False
set in the Person class, which the 0.4 docs say is
supposed to be set when planning to use transactions.
I'm not sure if that's what you were talking about.

> It is also possible
> that you *think* you are using transactions, but in fact its not
> enabled on your database.

I wasn't sure if creating an object could use the
Transaction object instead of the connection object,
but that's why I tried to re-get it from the database,
and got
AttributeError: 'Transaction' object has no attribute '_SO_selectOne'
which seems like a separate problem in and of itself.

> Those are just guesses though, i havent
> actually looked at the code.

Thanks for the help, though!  SQLObject seems very
cool; now, if I can only figure out how to use it
properly... :)

-- 
Randall Randall <ra...@ra...>
"You assist an evil system most effectively by obeying its orders and 
decrees." -- Mahatma Gandhi
"When you advocate any government action, you must first believe that 
violence is the best answer to the question at hand." -- Allen Thornton