Re: [Zope] dtml-calendar question (still not working)
This message is about how to use dtml-calendar to get it's data out of an odbc database on 3/8/00 5:35 pm, R. David Murray at [EMAIL PROTECTED] wrote: On Thu, 3 Aug 2000, tom smith wrote: I'm still getting allsorts of errors. My code is like this... dtml-let yearnr="date.yy()" monthnr="date.mm()" daynr="date.dd()" dtml-let startDateString="monthnr+'/'+daynr+'/'+yearnr" dtml-in expr="get_days_events(startDateString)" dtml-var EventName /dtml-in /dtml-let /dtml-let I'm having trouble passing StartDateString to get_days_events. If I look at StartDateString using dtml-var startDateString it looks OK. What kind of errors? I get Zope has encountered an error while publishing this resource. Error Type: Bad Request Error Value: ['startDateString'] the get_days_events() sql function looks like this... SELECT * FROM tblCalendar WHERE (startDate ='dtml-var startDateString 23:59:00' AND endDate = 'dtml-var startDateString 00:00:00') OR (startDate = 'dtml-var startDateString 00:00:00' AND startDate = 'dtml-var startDateString 23:59:00') ORDER BY startDate with startDateString entered into the arguments field I know the sql is a bit ugly but it's what I'm stuck with :-| I tried using dtml-sqlvar but it wrapped quotes around my date which also needs the time to work. ___ 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 )
Re: [Zope] dtml-calendar question (still not working)
on 3/8/00 10:14 am, Chris Withers at [EMAIL PROTECTED] wrote:
"R. David Murray" wrote:
On Thu, 3 Aug 2000, Andrew Kenneth Milton wrote:
| Well, yeah. A restricted python environment. The point being, it follows
| python syntax rules grin.
kind of... :-)
In what way does it *not* follow Python (expression) syntax rules?
_['something'] doesn't just return the value from the dictionary which
has the 'something' key, if it's callable, it'll try to call it and then
return that... not nice :(
If you want to be safe, use _.getitem('something',0)...
I'm still getting allsorts of errors. My code is like this...
dtml-let yearnr="date.yy()" monthnr="date.mm()" daynr="date.dd()"
dtml-let startDateString="monthnr+'/'+daynr+'/'+yearnr"
dtml-in expr="get_days_events(startDateString)"
dtml-var EventName
/dtml-in
/dtml-let
/dtml-let
I'm having trouble passing StartDateString to get_days_events. If I look at
StartDateString using dtml-var startDateString it looks OK.
one last attempt anyone?
cheers
tom
___
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 )
Re: [Zope] dtml-calendar question (still not working)
On Thu, 3 Aug 2000, tom smith wrote: I'm still getting allsorts of errors. My code is like this... dtml-let yearnr="date.yy()" monthnr="date.mm()" daynr="date.dd()" dtml-let startDateString="monthnr+'/'+daynr+'/'+yearnr" dtml-in expr="get_days_events(startDateString)" dtml-var EventName /dtml-in /dtml-let /dtml-let I'm having trouble passing StartDateString to get_days_events. If I look at StartDateString using dtml-var startDateString it looks OK. What kind of errors? --RDM ___ 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 )
