http://www.sqlalchemy.org/docs/sqlconstruction.myt says "Supported column operators so far are ... like(), startswith(), endswith(), between(), and in()". But between() seems not to work:
In [110]:s = users.select(users.c.age.between(30,39)) --------------------------------------------------------------------------- exceptions.AttributeError Traceback (most recent call last) /home/rmunn/projects/python/<ipython console> AttributeError: 'Column' object has no attribute 'between' This is consistent on SQLite and PostgreSQL. Trying "between_" doesn't seem to work either. What's the correct syntax for doing "SELECT * FROM users WHERE age BETWEEN 30 AND 39"? -- Robin Munn [EMAIL PROTECTED] GPG key 0xD6497014
