I am requiring users (or administrators) to enter an email address for every record (person).

When they don't supply an email I am prepending their user name to "@foo.foo" in order to create an email that CB accepts as valid but which will not be delivered anywhere.

Now I want to filter my "Valid Email" list to exclude all the foos, by creating a filter that says: email != %@foo.foo.

But this does not work and my email list is still all the records. I have tried to follow the CB_1.2.2_stable_manual.pdf around pp 132. But I have it wrong.

And when I view the list from the front end of the site, I cannot see the actual email that is associated with a user, only the words Email and Sendmail.

Thank you for any help.

Dear Support,

As said previously, I want to EXclude addresses with %@foo.foo, not to INclude them.

I was told not to use !=, and use LIKE, but there is no option to NOT LIKE.

If I use LIKE !@foo.foo it EXcludes all emails ---979 of them.

If I have no filter I get 979.

There are only about 2-300 good emails. That is what I would like to send to.

Hope you can help. site is at fcat-nc.org.

Thank you.

OK. Have tried to use advanced search with string

But get:
=============
JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%@foo%)' at line 6 SQL=SELECT COUNT(*) FROM jos_comprofiler ue, jos_users u WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND u.gid IN (18, 30) AND u.`id` = ue.`id` AND

===>>> (email NOT LIKE %@foo%) <<<===
Also: email NOT LIKE %@foo.foo
And with email and or %@foo... in back quotes.

Still no happiness; I either get no records or all 980 of them.


Call stack
# Function Location
1 JSite->dispatch() /home/fcat-nc/public_html/index.php:68
2 JComponentHelper->renderComponent() /home/fcat-nc/public_html/includes/application.php:124
3 require_once() /home/fcat-nc/public_html/libraries/joomla/application/component/helper.php:162
4 usersList() /home/fcat-nc/public_html/components/com_comprofiler/comprofiler.php:102
5 cbUsersList->drawUsersList() /home/fcat-nc/public_html/components/com_comprofiler/comprofiler.php:781
6 CBdatabase->loadResult() /home/fcat-nc/public_html/administrator/components/com_comprofiler/library/cb/cb.lists.php:304
7 JDatabaseMySQL->loadResult() /home/fcat-nc/public_html/administrator/components/com_comprofiler/library/cb/cb.database.php:733
8 JDatabaseMySQL->query() /home/fcat-nc/public_html/libraries/joomla/database/database/mysql.php:355
9 JError->raiseError() /home/fcat-nc/public_html/libraries/joomla/database/database/mysql.php:231
10 JError->raise() /home/fcat-nc/public_html/libraries/joomla/error/error.php:171
11 JException->__construct() /home/fcat-nc/public_html/libraries/joomla/error/error.php:136
=============