Re: [Zope] Sql statement in dtml code

2005-09-09 Thread Peter Bengtsson
Try to locate what causes this error by commenting things out one by one. Eventually you'll be able to locate the culprit which someone on the list might be able to help you with. On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Ok, I've made a few changes, and now I get this error: > >

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread paul . hendrick
Ok, I've made a few changes, and now I get this error: Site Error An error was encountered while publishing this resource. AttributeError Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 175, in publish_module_standard * Module Products.

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread Peter Bengtsson
Like Joe said, have you confused the critical difference between "sql_select_counts" and "sql_select_counts.zsql" On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > I've attached the two files that I'm using > Full error is this: > > Site Error > An error was encountered while > pub

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread paul . hendrick
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_

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread Joe Bezier
OK, are you using a Zope with an error_log? [you'll see it in the root of your installation]. If so, could you pass on the whole traceback for this error? Hang on - are you calling 'date_count' when your object's called 'date_count.zsql'? Rename your zsql method 'date_count' and then try - I

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread 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, [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 en

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread paul . hendrick
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: Thanks for the replies so far! Paul On Fri, 2005-09-09 at 11:30 +0100, Peter Bengtsso

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread Peter Bengtsson
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,

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread paul . hendrick
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 - 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 wr

Re: [Zope] Sql statement in dtml code

2005-09-09 Thread Joe Bezier
I'm not sure if this is what you're looking for expr="sql_statement(parameter1=parameter1,parameter2=parameter2)"> If no parameters, just expr="sql_statement()" or 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

[Zope] Sql statement in dtml code

2005-09-09 Thread paul . hendrick
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