On Jan 24, 2012, at 7:55 PM, wuestenarchitekten wrote: > Hello, > > completely new in python and sqlalchemy. My setup is win7, MySQL > 5.5.16, Python 3.2.2, sqlAlchemy 0.7.4 and MySQL-python via this > website: http://www.lfd.uci.edu/~gohlke/pythonlibs/ > > > if I run a query like this: > > for fname in session.query(t.Athletes.first_name): > print(fname) > > > I get a result yet running > > for fname in session.query(t.Athletes.first_name).first(): > print(fname) > > > the error pasted at the bottom of the message comes up. > > Is this a problem because of MySQL-python not being supported for > python32 in conjunction with sqlalchemy and if, what package should I > install? Is there a recommendation for python32? I tried oursql but > couldn't get a simple query to work with it either. The error looks > like the %s is not evaluated?
It's probably py3K related. oursql is the one that works on py3K right now. On Python 3, the strongest backends are SQLite and Postgresql via psycopg2. If you really need a smooth experience with MySQL and things aren't working right on 3, try Python 2.7 for now. -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
