[Typo3] Count of records

[matthi]

Dawit wrote:
> Hi list
> 
> I am a newbee to typo3 and I want to display the number of records a the page contains after the menu.  The pages contain list of link records in a table (say tx_table), and really want to show how many link records the page contains after the menu, for ex:
> 
> Businness (7)
> Sports (5)
> 
> I know this has something to do with the numRows object of typoscript and i attempted this:
> 
> subparts.LEFTNAV.2 = TMENU
>    subparts.LEFTNAV.2 {
>   
>    expAll = 1
>    
>    temp.60 = TEXT
>    temp.60.value  {
>          numRows  {
>              table = tx_cmwlinklist_link
>              select.pidInList.data = field : uid
>              } 
>     }
> 
>    NO.before.data < temp.60.value
>    NO.before.data.Wrap = ( | )
>    NO.allWrap =  <tr><td bgcolor="#A1C5E0" width=1>&nbsp;</td><td><img src="clear.gif" width="15"></td><td class="leftnav2"> | </td></tr>
> 
>    ACT = 1
>    ACT.allWrap = <tr><td bgcolor="#0063AC" width=1>&nbsp;</td><td><img src="fileadmin/templates/smartcape/images/arrow_blu.gif"></td><td class="leftnav2-act"><b> | </b></td></tr>
> 

Try:

subparts.LEFTNAV.2 = TMENU
subparts.LEFTNAV.2 {
    NO.after.numRows  {
      table = tx_cmwlinklist_link
      select.pidInList.field =  uid
    }
NO.after.wrap = <b>&nbsp;( | )</b>
NO.allWrap = <div class="blblablabl> | </div>
....


SO, given you that code without any warranty I hope it works,as I had 
implemented this sucessfully once but looking for contentitems in a 
givenstoragepage...so I am not sure about the
select:pidInList.filed = uid line....

Maybe should be replaced by yourline

Anyhow and anyway, good luck

regards

matthias oesterle