I'm trying to determine how many records are in a table I'm looking at:
http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_functions I tried this: order.priority = \ session.query(Order).select([func.count(Order.c.id)]).execute()[0][0]+1 I get: update_order_accpac_info order.priority = session.query(Order).select([func.count(Order.c.id)]).execute()[0][0]+1 File '/usr/local/src/sqlalchemy/lib/sqlalchemy/orm/query.py', line 226 in select return self.select_whereclause(whereclause=arg, **kwargs) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/orm/query.py', line 231 in select_whereclause statement = self.compile(whereclause, **kwargs) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/orm/query.py', line 360 in compile statement = sql.select([], whereclause, from_obj=from_obj, use_labels=True, **kwargs) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/sql.py', line 53 in select return Select(columns, whereclause = whereclause, from_obj = from_obj, **kwargs) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/sql.py', line 1431 in __init__ self.append_whereclause(whereclause) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/sql.py', line 1487 in append_whereclause self._append_condition('whereclause', whereclause) File '/usr/local/src/sqlalchemy/lib/sqlalchemy/sql.py', line 1493 in _append_condition condition.accept_visitor(self._wherecorrelator) exceptions.AttributeError: 'list' object has no attribute 'accept_visitor' even typingin IPython just session.query(Order).select([func.count(Order.c.id)]) gives the same error. I'll just use connection.execute() I guess.. But I'm curious if this is a docs issue, or I'm doing something wrong. -- Brad Clements, [EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users