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

[Bruno Nana]

> 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
>