On Mon, Sep 7, 2009 at 12:33 PM, GuyBowden <guy.bow...@gmail.com> wrote:
> > Hi, > > I'm trying to use XXXX__range=(then, now) to filter my queryset > > However the SQL that is being generated is missing the quotes around > the dates - it looks like this: > > ...... xxxxx BETWEEN 2009-09-01 and 2009-09-07 > > but it should look like this: > > ...... xxxxx BETWEEN '2009-09-01' and '2009-09-07' > > > (note the quote marks) > > What's going on? how can I fix this? > > How are you determining that the quotes are missing? If you are looking at connection.queries then missing quotes is not a problem -- the SQL logged in connection.queries is logged there before the DB backend gets the query, so before the DB backend add quotes. Are you actually seeing a problem with the query execution? I just tryied a similar query on my DB (also MySQL) and don't see any problem. Karen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
