Weird:
syslog.syslog("Connections = %s" % str(connection.queries))
gives:
May 31 12:18:41 localhost python: Connections = []
On May 31, 12:12 pm, Stodge <sto...@gmail.com> wrote:
> Thanks. The various pieces of data (self.name etc) are 100% correct -
> I dumped them all using syslog. However, it just occurred to me that
> maybe it's a unicode/string issue. I'm trying to dump the SQL that's
> generated - debug_toolbar isn't working for me.
>
> The timestamps are generated from the request and they too are
> correct, assuming here that year, month and day have the correct
> values:
>
> today = datetime.datetime(self.req_year, self.req_month,
> self.req_day)
> tomorrow = today + datetime.timedelta(days=1)
>
> Thanks
>
> On May 31, 12:08 pm, Javier Guerra Giraldez <jav...@guerrag.com>
> wrote:
>
>
>
> > On Mon, May 31, 2010 at 9:56 AM, Stodge <sto...@gmail.com> wrote:
> > > I have a query that filters on four fields:
>
> > > res = MyModel.objects.filter(name=self.name,
> > > type=self.type,
> > >
> > > last_update_time__gte=today,
> > >
> > > last_update_time__lte=tomorrow)
>
> > > If I enter the exact same query in the shell, I get the correct
> > > results from the database. If I access my app through the browser and
> > > let it run the query, I get zero results. The settings file is correct
>
> > all four of these parameters need some context (the 'self' object, and
> > those 'today' and 'tomorrow' variables). obviously, you couldn't just
> > type that in the shell and get any result. so, the problem might lay
> > in some other code you're not showing.
>
> > just guessing: something that has bitten me before is that even if
> > querysets are lazy, the paraemters it gets aren't. specially when
> > they're time dependent, like 'today' and 'tomorrow'. if you're
> > creating this queryset at startup, these values might not be correct
> > when you finally evaluate the query.
>
> > --
> > Javier
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@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.
