[sqlalchemy] MultipleResultsFound

2011-03-30 Thread jose soares
Hi all, I got, for the first time the following error: ../lib/python2.6/site-packages/SQLAlchemy-0.6.0-py2.6.egg/sqlalchemy/orm/query.py, line 1417, in one Multiple rows were found for one()) MultipleResultsFound: Multiple rows were found for one() Does anyone know what that means? j

Re: [sqlalchemy] MultipleResultsFound

2011-03-30 Thread Mike Conley
You issued a query with a .one() qualifier and there is more than one row in the database satisfying the condition. Example: 2 names in a table firstname=pete, lastname=smith firstname=john, lastname=smith query for rows lastname=smith with .one() will fail because there are 2 smith in database

Re: [sqlalchemy] MultipleResultsFound

2011-03-30 Thread jose soares
Mike Conley wrote: You issued a query with a .one() qualifier and there is more than one row in the database satisfying the condition. Example: 2 names in a table firstname=pete, lastname=smith firstname=john, lastname=smith query for rows lastname=smith with .one() will fail because there