> -----Original Message----- > From: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jack2318 > Sent: 11 June 2008 17:50 > To: sqlalchemy > Subject: [sqlalchemy] text > > > I tried very simple test: > > s = text("SELECT COUNT(*) FROM table WHERE field LIKE 'something'") > count = conn.execute(s).fetchone() > > and this produced error > Unexpected error: <type 'exceptions.TypeError'> not enough arguments > for format string > > not big deal there is few way around but just for completeness I > believe it should work (no parameters to expand) > > regards > -- jacek > PS: I am using mysql
Are you sure you didn't try: s = text("SELECT COUNT(*) FROM table WHERE field LIKE 'something%'") Ie. Included a percent sign in the query? I think that sql strings get passed through python's % substitution function at some point in SQLAlchemy (or possibly the DBAPI driver), so you need to use '%%' instead of '%'. Hope that helps, Simon --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---