[Zope] Searching and only one result.

[J. Cone]

If you are using Oracle, you can ask it to
  select <name>, count(*) from <articles> where <name> like <sqlvar
letter>||'%' group by <name>

where <name> is your name column, containing Annie, and <articles> is the
table that contains it, and <sqlvar letter> is the right DTML way of
getting the letter your user provided into the query.

Gasper may or may not do the same.

At 15:46 10/07/01 +0200, James van der Veen wrote:
>Hi everyone,
>
<snip>
>for instance: Albert wrote 2 articles and Annie 3
>a person on the site searches for the A. 
>Now it will give 
>Annie
>Annie
>Annie
>Albert
>Albert
>
>But the thing I want to do is that it will do this:
>Annie (3) click here to see all annies ........
>Albert (2) click.........
>
>Can any of you help me with this?
>
>Sure hope so!!
>
>James
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>**   No cross posts or HTML encoding!  **
>(Related lists - 
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>
>