[TYPO3-english] question about function numRows from Typoscript

[Yordan Ivanov]

Hi List,
I want to count number of records that have a certain email,
I have tired the following snippet, but no output. I have modified an example that is working
here is the snippet:

lib.test = COA
lib.test {
  10 = LOAD_REGISTER
  10.menuNumber.numRows {
    table = tx_testformata_domain_model_formata
   select.pidInList = 0
   #select records with a certain email
    select.where = email=example at gmail.com
  }

  20 = TEXT
  20.dataWrap = <div>There are {register:menuNumber} records</div>
}

All of the examples were with table "pages", also  "pidInList" is 0 in the table for all the records.

many thanks
Jordan