Peter Bengtsson wrote:

I'm letting "untrusted" visitors post HTML by the use of StructuredText rules. If they create some <h3> or <pre> tags I don't care, but I don't want people to be able to post rendered <textarea cols=100 rows=100> (with no closing tag) for example.

Is Strip-o-Gram the thing for me then?

Yup, Squishdot uses it for exactly that with Structured Text postings :-) Chris

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.