On Mon, Jan 19, 2009 at 11:49 AM, Matias Surdi <matiassu...@gmail.com>wrote:
> > Hi, > > > I'm trying to run a sql query with parameters taken from a dict, here is > the relevant part of the code: > query = "select * from table where name='%(name)s'" Remove the single quotes around '%(name)s'. The backend will handle quoting, I expect the extra quotes are causing confusion somewhere. Karen > > parameters = {'name':'valueofname'} > cursor = connection.cursor() > data = cursor.execute(query,parameters) > > > The error I get is: > > TypeError: format requires a mapping > > > But, as far as I know (from PEP249) this should be possible. > Basically, what I need, is to pass the parameters values in a dict, and > not as a list or tuple as is shown in django docs. > > Which is the correct way to accomplish this? > > Thanks a lot. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---