use an "and_()" around those two criterion, or use selectfirst_by
(). in the next release, the arguments to selectfirst() are more
accurately stated instead of using *args and you wont get that error.
On Mar 19, 2007, at 2:37 PM, [EMAIL PROTECTED] wrote:
>
> Howdy All,
>
> I'm getting an odd exception when I try to run a query:
>
> '_BooleanExpression' object has no attribute 'has key'
>
> The function call looks like this:
>
> rwMyRow =
> qMyQuery.selectfirst
> (cdbUserVerification.c.ticket_serial==TicketSerial,
> self.tblUserVerification.c.expire_datetime > 'now()')
>
> The traceback looks like this. Any ideas?
>
> Thanks,
> -Josh
>
> Traceback (most recent call last):
> File "/home/josh_dev/dev/biblio/biblio_db.py", line 49, in ?
> c.PassAuthUser('abcabc')
> File "/home/josh_dev/dev/biblio/biblio_db.py", line 40, in
> PassAuthUser
> rwMyRow =
> qMyQuery.selectfirst
> (cdbUserVerification.c.ticket_serial==TicketSerial,
> self.tblUserVerification.c.expire_datetime > 'now()')
> File "build/bdist.linux-i586/egg/sqlalchemy/orm/query.py", line 220,
> in
> selectfirst
> File "build/bdist.linux-i586/egg/sqlalchemy/orm/query.py", line 258,
> in
> select_whereclause
> File "build/bdist.linux-i586/egg/sqlalchemy/orm/query.py", line 384,
> in
> _select_statement
> File "build/bdist.linux-i586/egg/sqlalchemy/orm/query.py", line 314,
> in
> execute
> File "build/bdist.linux-i586/egg/sqlalchemy/orm/session.py", line 142,
> in
> execute
> File "build/bdist.linux-i586/egg/sqlalchemy/engine/base.py", line 266,
> in
> execute
> File "build/bdist.linux-i586/egg/sqlalchemy/engine/base.py", line 297,
> in
> execute_clauseelement
> File "build/bdist.linux-i586/egg/sqlalchemy/sql.py", line 520, in
> compile
> File "build/bdist.linux-i586/egg/sqlalchemy/sql.py", line 397, in
> compile
> File "build/bdist.linux-i586/egg/sqlalchemy/sql.py", line 1630, in
> accept_visitor
> File "build/bdist.linux-i586/egg/sqlalchemy/ansisql.py", line 396, in
> visit_select
> AttributeError: '_BooleanExpression' object has no attribute 'has_key'
> Script terminated.
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
