A DATE logically spans a 24 hour period, so if I understand what you
are trying to do, you need a BETWEEN qualifier that spans that range
of timestamps from 00:00:00 to 23:59:59.... on that date.
Andrus
On Jun 18, 2007, at 9:44 PM, Kevin Menard wrote:
Hi,
I've been playing around with django a lot lately and they have a
concept of "generic views", which basically is a way to list
objects by
date and/or slug. I decided to try doing this with my Tapestry 4 app,
but have been running into problems. In particular, one of my models
uses TIMESTAMP for its "pubDate" field. Generally, I do want to have
both the date and time information, but I'd like to query by date and
slug. It is assumed that there is a unique combination of both.
Ex.:
http://www.example.com/2007/06/18/some-slug-text
I've been trying to build up a java.util.Date based on the information
provided in that URL and pass it off to a named query. The query
executes just dandy, but I get nothing back because the time values do
not match. Is there anyway to do a type conversion and just
compare by
the date portion?
Thanks,
Kevin
Kevin Menard
Servprise International, Inc.
800.832.3823 x308
