Chris Beaumont wrote:
Hello,
I'm using dtml-in to display a long list of events taken from a SQL
table, as part of a calendar, using batch processing,
(basically the example from the DTML reference adapted to use direct
traversal to fetch the table contents)
I want my calendar to be basically a timeline, with the current date as
the default starting point. The idea is that someone can go back in time
as well as forward. (links for past events as well as future)
So, basically, I'm looking for a not-too-convoluted (i.e. decent
performance) way to have the 'default' screen on entry be the batch that
contains the item whose datetime value is the next one occurring after
the current time. Dtml-in doesn't seem to have a straightforward way to
do this, unless I'm overlooking something obvious.
Does a solution to this occur to anyone?
do it in sql, this is pretty database dependent, but the ideal way to me
would be just
where event_date dtml-var TimeArguement fmt=dbdateformat
and just adjust your dtml to call the method with a date arguement.
you probably need to use your db's string-date functions to convert the
value for comparisions.
i think this would offer the best performance, and least code.
cheers
kapil
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )