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?

I'm using Django 1.02 with MySQL 5.1.30

The column is a 'Date' column rather than a Datetime.

Cheers
Guy



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to