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 think that should do it. If not, send us the traceback...
Cheers
JB
On 9 Sep 2005, at 11:33, [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 )
___________________________________________________________
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 )
