Limit a CB List

Hi, simple question :
How can I limit the number of results of the query ?

Exemple : only the 5 first results of (`cb_gender` = 'Male' )

I try
(`cb_gender` = 'Male' ) LIMIT 5
and
SELECT count(*) FROM `#__comprofiler` limit 5


without success ;-(
Help please

You can't, that's not how a userlist is designed to function. Its limit is the criteria it's trying to match. It displays as many users possible within that criteria. I suppose you could set the paging limit to 5 then hide the pagination links using CSS though.