phpmyadmin / error-reporting-server

		 * for how to use Sql functions with cake

		 */

		switch ($fieldName) {

			case 'browser':

				// SUBSTRING(browser, 1, LOCATE(' ', Incidents.browser)-1))

				$field = $groupedCount->func()->substring([

					$fieldName=>'literal',

					"1" => 'literal',

					"Locate(' ', Incidents.browser)-1" => 'literal'

					]);

				break;

			case 'server_software':

				// SUBSTRING(server_software, 1, LOCATE('/', Incidents.server_software)-1))

				$field = $groupedCount->func()->substring([

					"Locate(' ', Incidents.browser)-1" => 'literal'

					]);

				break;

			case 'server_software':

				// SUBSTRING(server_software, 1, LOCATE('/', Incidents.server_software)-1))

				$field = $groupedCount->func()->substring([

					$fieldName=>'literal', "1" => 'literal',

					"Locate('/', Incidents.server_software)-1" => 'literal'

					]);

				break;

			default:

				$field = $fieldName;

		}