On 7/9/07, Srinivasan R <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I have a TG application running on SQLObject / Postgresql. I have a
> datetime column and need to select articles which were published
> between two particular date ranges.
> The online docs of SO weren't of much help.
Its a shame the docs are so poor because SO is quite a decent ORM
(though I myself had a period when I disliked it because of the lack
of documentation)
-----------------------------------------------------------------------------
from sqlobject.sqlbuilder import AND
import datetime
starttime = datetime.datetime(2007, 01, 12)
endtime = datetime.datetime(2007, 02, 25)
res = Klass.select(AND(
Klass.q.publish_time >= starttime,
Klass.q.publish_time <= starttime
))
-----------------------------------------------------------------------------
I wrote this directly in gmail without testing but you get the idea.
Cheers,
Florent.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
