[SOLVED] Error is display list with regex

Hi,

Thanks to this great component we can have user profiles and make lists of users who have the same value on the 'cb_team' field.

We migrated to joomla 3.1.5 from 2.5.14

We use this code with advanced filter in lists.
But when there is no value the 2.5.15 site gave a message 'you are not in a team'.
But now we get this error:
How can we edit the regex to get the right message or 'nice' message instead of an error.

Joomla version doesn't matter. You can't have an empty REGEXP as it'll error MYSQL. You're probably better off using FIND_IN_SET and comma delimitering your field. I assume your field is a multi-select fieldtype in which case it's stored as |*| delimitered. So the below should work for your needs.


The above usage is faster than REGEXP and won't error on empty values. REGEXP is very sensitive so I suggest only using it when you can absolutely guarantee the REGEX.

Hi krileon

The field is a text field With values like 150,176

Or by example: staf,150

Will your suggestion also work With comma seperated values in a text field?

Nice. It is working.

Thank you!

HI Krileon,

The reqex is not working when there are 2 values comma seperated in the cb_teams field.

How can we modify the regex to let it work?

You can't do that with FIND_IN_SET. The first argument always has to be a string. It can not compare a comma separated list of strings against another comma separated list of strings. You'll probably need some sort of custom MYSQL function to handle your specific case as you can not have an empty REGEXP usage so using REGEXP won't be possible in your case unless you can guarantee some sort of value (maybe a substitution IF statement to force a value of some kind).