[Zope] Sql statement in dtml code

[Peter Bengtsson]

And this doesn't work when you refresh?? I find that hard to believe.
What's the error (including traceback)

On 9/9/05, paul.hendrick at gmail.com <paul.hendrick at gmail.com> wrote:
> sorry, i meant when i run the code - i'm not with zope terminology yet.
> here's my date_count.zsql method:
> select count(*) AS endcount from t_transaction
> 
> and in the dtml, i've got:
>         <dtml-in date_count>
>             <dtml-var endcount>
>         </dtml-in>
> 
> Thanks for the replies so far!
> Paul
> 
> On Fri, 2005-09-09 at 11:30 +0100, Peter Bengtsson wrote:
> > When the page is refreshed??? It shouldn't matter. It's got to be
> > something wrong with the SQL statement.
> >
> > A ZSQL method doesn't really have "an output", you have to loop over
> > it and get the "output" for each key in the iterations.
> >
> > On 9/9/05, paul.hendrick at gmail.com <paul.hendrick at gmail.com> wrote:
> > > 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
> > > >
> > >
> > > _______________________________________________
> > > 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 )
> > >
> >
> >
> 
> 


-- 
Peter Bengtsson, 
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com