[Zope] Calendar tag backed by database?

[Loren Stafford]

Here's an example that I'm currently developing to display an Outlook
Calendar that has been exported to an MSAccess database. The Access ODBC
query 'DateLookup' is:

select Subject, StartDate, EndDate, Location, Description, Showtimeas from
Calendar
  where StartDate <= #<dtml-var "ThisDate" fmt="%m/%d/%Y" sql_quote>
12:01:00 AM#
  and   EndDate >= #<dtml-var "ThisDate" fmt="%m/%d/%Y" sql_quote> 11:59:00
AM#

The DTML is:

<dtml-call "REQUEST.set('colorAssignment',{})">
<dtml-call "REQUEST.set('nextColor',0)">
<dtml-calendar weekdays="07">
<dtml-call "setCalendar('bordercolor', '0000CC')">
<dtml-call "setCalendar('spacing', '2')">
<dtml-call "setCalendar('padding', '2')">
<dtml-call "setCalendar('valign', 'top')">

<dtml-if "_.DateTime.isCurrentDay(date) and _.DateTime.isCurrentMonth(date)
and _.DateTime.isCurrentYear(date)">
<dtml-call "setCalendar('cellbgcolor', 'CCCCCC')">
</dtml-if>

<span style="font-size: 9pt; font-weight: bold; font-family: Verdana,
Helvetica, sans-serif;">
<dtml-var date fmt=%d>
</span>
<dtml-call "REQUEST.set('ThisDate', date)">
<dtml-in DateLookup sort=Showtimeas>

<dtml-call "REQUEST.set('statusColor',StatusColors[0])">
<dtml-if Showtimeas>
<dtml-call "REQUEST.set('statusColor',StatusColors[_.int(Showtimeas)])">
</dtml-if>
<span style="font-size: 8pt; font-family: Verdana, Helvetica, sans-serif;
color: black;
background-color: #<dtml-var statusColor>;">
<br><A onMouseOver="return overlib('Show time as: <dtml-var
"ShowTimeAsText[Showtimeas]"> (<dtml-var Showtimeas>)', RIGHT);"
onMouseOut="nd();"><dtml-var Subject></A><br>
</span>
</dtml-in>

</dtml-calendar>

-- HTH
-- Loren

> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Frank
> McGeough
> Sent: Monday, August 20, 2001 06:26
> To: zope@zope.org
> Subject: [Zope] Calendar tag backed by database?
>
>
> Is their an example of using the calendar tag where the calendar
> entries are
> using a SQL database? I'm having trouble getting date based
> queries to work
> with MySql and also in understanding where the queries should go
> in my DTML
> method that include the calendar tag.
>