Hi, I've attached the two files that I'm using Full error is this: Site Error An error was encountered while publishing this resource. KeyError Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 175, in publish_module_standard * Module Products.PlacelessTranslationService.PatchStringIO, line 51, in new_publish * Module ZPublisher.Publish, line 132, in publish * Module Zope.App.startup, line 204, in zpublisher_exception_hook * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.CMFCore.FSDTMLMethod, line 141, in __call__ * Module DocumentTemplate.DT_String, line 474, in __call__ * Module Products.CMFCore.FSDTMLMethod, line 134, in __call__ * Module DocumentTemplate.DT_String, line 474, in __call__ * Module DocumentTemplate.DT_In, line 623, in renderwob KeyError: 'sql_select_counts' ____________________________________ Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to error log. If the error persists please contact the site maintainer. Thank you for your patience. On Fri, 2005-09-09 at 11:48 +0100, Peter Bengtsson wrote:
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@gmail.com <paul.hendrick@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@gmail.com <paul.hendrick@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@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@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@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 )