[Typo3] count newsletter subscribers

[Gregor Kaczmarczyk]

hi Thorsten,

you make my day :)

my final solution:

temp.abonnenten = CONTENT
temp.abonnenten {
   table = tt_address
   select {
     selectFields =  count(*) as count
     where = deleted = 0
     pidInList = 3
   }
   renderObj = TEXT
   renderObj {
     field = count
     noTrimWrap = || Abonnenten|
   }
}

renderObj is the trick, thank you for the hint.

Thorsten Kahler schrieb:
> PS: Thanks for your suggestion to add the number of recipients to 
> direct  mails.
> PPS: Probably you will have to fine-tune the select statement to 
> exclude  hidden addresses etc.
for every mass mail we make a full import of the user data so int his case i 
don´t need to concern about hidden records.

...and  a new quiestion occurs...
but that´s a new thread.

ciao, greg