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, [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  -  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 )
> > > >
> > >
> > >
> > 
> > 
> 
> 
SELECT COUNT(*) AS tcount FROM t_transaction 
<dtml-comment>
    Despite the name of this form (it's usually used to provide a 
    form wrapper around a selection screen) I am using this here
    to provide a title to the page.     
</dtml-comment>


<table width="100%">
<tr>
<td align="center">
<dtml-in sql_header size="1">

<h1><b>Transactions for <dtml-var PARTCODE> - <dtml-var KANBAN> - <dtml-var 
PARTDESCRIPTION> - <dtml-var CLIENTCODE></b></h1>

<dtml-if showvalue>
        <p align="right"><a href="/crocus/ui/stock/transaction?pmid=<dtml-var 
pmid><dtml-if s_date>&s_date=<dtml-var s_date></dtml-if><dtml-if 
s_time>&s_time=<dtml-var s_time></dtml-if><dtml-if s_dateto>&s_dateto=<dtml-var 
s_dateto></dtml-if><dtml-if s_timeto>&s_timeto=<dtml-var 
s_timeto></dtml-if>&showvalue=">Hide Value</a></p>
<dtml-else>
        <p align="right"><a href="/crocus/ui/stock/transaction?pmid=<dtml-var 
pmid><dtml-if s_date>&s_date=<dtml-var s_date></dtml-if><dtml-if 
s_time>&s_time=<dtml-var s_time></dtml-if><dtml-if s_dateto>&s_dateto=<dtml-var 
s_dateto></dtml-if><dtml-if s_timeto>&s_timeto=<dtml-var 
s_timeto></dtml-if>&showvalue=1">Show Value</a></p>
</dtml-if>

</dtml-in>
</td>
</tr>
</table>
<table>
<tr>
    <td>
    <b>Inbound:</b>
    </td>
    <td>
        <dtml-in sql_select_counts>
            <dtml-var tcount>
        </dtml-in>
    </td>
</tr>
<tr>
    <td>
    <b>Outbound:</b>
    </td>
    <td align="left">
    ...
    </td>
</tr>
</table>
_______________________________________________
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 )

Reply via email to