Latest: ChronoForms v8.0.51 update

CCV5 Syntax for FIND_IN_SET

Use FIND_IN_SET in CCv5 model conditions.

Overview

The issue is not knowing the correct syntax to implement the FIND_IN_SET function within a model's conditions or join conditions.
Return an array where the key is the field name and the value is an array containing the set of values to match.

si simelas 26 Jun, 2017

Hi Bob, Hi Max,

wondering what is the right syntax to use in CCV5 for a Model in Conditions or Join Conditions for "FIND_IN_SET"

Best

simelas

Max_admin 27 Jun, 2017

Answer

Hi Simelas,

return array("field" => array("1", "2", "3"));

Best regards,
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.