[Typo3] count newsletter subscribers

[Thorsten Kahler]

Hi Gregor,

I'd suggest two changes:
- use a column name in your result set, that can be used with the  
stdWrap.field syntax
- add a renderObj that puts out the result

e.g. append / change these lines

abonnenten.select.selectFields = count(*) as count
abonnenten.renderObj = TEXT
abonnenten.renderObj {
   field = count
   noTrimWrap = |At the moment | subscribers get this newsletter.|
}

HTH
Thorsten

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.


Am Thu, 30 Jun 2005 15:43:33 +0200 schrieb Gregor Kaczmarczyk  
<gregor at crazes.de>:

> hi list,
>
> i try to insert danamically the number of subscribers with TS.
> but no luck so far. :(
>
> abonnenten = CONTENT
> abonnenten {
>    table = tt_address
>    select {
>    selectFields = count(*)
>    pidInList = 3
>    }
> }
>
> has anybody a clue how to retrive this value without PHP using a marker?
>
> thx in advance.
>
> regards,
> gregor



-- 
No Subject - No Realname - No Service!
Respect the List/Newsgroup Rules!
  >> http://typo3.org/1438.0.html <<

It's not a bug - it's an undesired feature.