[Zope] Sql statement in dtml code

[paul.hendrick at gmail.com]

Hi Joe, 
thanks for the quick reply!
i've got a zsql method now(called date_count.zsql) which I try to call
in my dtml via <dtml-in date_count> - but I get a KeyError when the page
is refreshed. The dtml is in the same dir as the zsql...not sure whats
up.

Cheers,
Paul

On Fri, 2005-09-09 at 11:06 +0100, Joe Bezier wrote:
> I'm not sure if this is what you're looking for
> 
> <dtml-in 
> expr="sql_statement(parameter1=parameter1,parameter2=parameter2)">
> <dtml-var column_name>
> </dtml-in>
> 
> If no parameters, just expr="sql_statement()" or <dtml-in sql_statement>
> 
> Cheers,
> 
> JB
> 
> 
> On 9 Sep 2005, at 10:50, paul.hendrick at gmail.com wrote:
> 
> > Hi all,
> > I'm trying to basically get the output of two SELECT statements into a
> > dtml document, but cant get it working.
> > I've searched, and tried a few examples for similar things, but had no
> > luck. Can anyone recommend a way, please?
> >
> > Thanks,
> > Paul
> >
> > _______________________________________________
> > Zope maillist  -  Zope at zope.org
> > http://mail.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://mail.zope.org/mailman/listinfo/zope-announce
> >  http://mail.zope.org/mailman/listinfo/zope-dev )
> >
> 
> 
> 	
> 	
> 		
> ___________________________________________________________ 
> Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com
>