Executing the SQL statement in a Members list menu item

Hi Tuan,
We want to run a number of bespoke SQLs to provide lists of members along the lines of:
SELECT  * FROM `liv_osmembership_field_value` WHERE `field_id` = 37 AND `field_value` CONTAINS "Ice Creams"

It appears that the Menu item screen is truncating the statement because we get the following message:  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 'SELECT * FROM `#__osmembership_field_value` WHERE `field_id` = 37 AND `field_v' at line 5.

Are we doing something wrong?

Thanks

Peter

Hi Peter

The SQL command you are using does not look right to me. Could you change it to :



Then check to see if it works ?

Tuan

Thank you, this works perfectly, well done and thanks for the speedy service!

You're welcome. Happy to hear that it helped