Parse error

sm

smurf007 13 Jun, 2014

Hi,

Got the following Parse error while I've used the following Conditions in CCv5:

<?php
$user =& JFactory::getUser();
?>
<?php
return array(":Risicos.id NOT IN (SELECT id
FROM 4Beheersmaatregel WHERE 4Beheersmaatregel.user_id = $user->id)" ORDER BY Risicos.id);
?>

Parse Error:

Parse error: syntax error, unexpected T_STRING, expecting ')' in /public/sites/www.risman-tools.nl/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php(245) : eval()'d code on line 6

How to fix it?

sm

smurf007 26 Jun, 2014

Hi,

No solution?

Greetz

Gr

GreyHead 26 Jun, 2014

Hi smurf007,

Fix the quote problem in line 6

return array(":Risicos.id NOT IN (SELECT id
FROM 4Beheersmaatregel WHERE 4Beheersmaatregel.user_id = $user->id)" ORDER BY Risicos.id);

Bob

Max_admin 30 Jun, 2014

Please note that sub queries are not supported, so this may or may not work even if no errors are generated, you can enable and check the debug for the final generated SQL statement!

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.