[Zope-dev] Problem by counting the number of result of database query

Hi,

I have one problem with a Zmethod.

Here is the method:

select *,summe=sum(count(*)) from neuigkeiten where ( username like '%<!--#var suche-->%' or autorloginname like '%<!--#var suche-->%' or headline like '%<!--#var suche-->%' or textfeld like '%<!--#var suche-->%') order by headline

That is i want to select some data from database and save the number of data who are found in summe.(Number found:<dtml-var summe> is ok) There is no error at this level, but there is a problem when i list the result in the dtml document. There are more data as i need.

Please would you help me to resolv this problem!!

Thank

Bruno