I have an SQLObject question. I'm hoping that someone here has perhaps
encountered a similar problem and is willing to share some experiences
:)

Anyway...

What I have is a table where every row is a visit record.

class View(SQLObject):
        ip = UnicodeCol(length = 50)
        time = DateTimeCol(default = datetime.datetime.now)
        site = ForeignKey("Page")

What I need is, given a page ID, a data structure holding, for the
last n days, the date and the number of views on that date.

I'm having a hard time coming up with an SQLObject select() for doing
this. Has anyone tackled a similar problem and could perhaps point me
in the right general direction?


Elver

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

Reply via email to