And this doesn't work when you refresh?? I find that hard to believe. What's the error (including traceback)
On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] 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 - [email protected] > > > > > 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 - [email protected] > > > 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 _______________________________________________ Zope maillist - [email protected] 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 )
