Hi,
In cc5, i don't understand the syntax of the where condition : "The where conditions in array format: return array("field_name" => "XYZ");"
My field is COPROMOTER and i want to list the record where this field in not null.
Simple isn't it ? But i can't do it ! 😟
Thank you for helping me,
Marc
Hi Marc,
Did you try v6 ? if you are starting a new project then its better to use v6
You may try this condition in v5:
return array(":field_name IS NOT NULL");
Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Hi Max,
Thank you for your quick response.
I try it but it didn't work...
I don't understand the syntax of these conditions 😟 i am so sorry.
I put two screen capture, maybee i do un mistake...
Thank you for your help,
Marc.
Hi Marc,
You must have the code after a php tag:
<?php
return array(":field_name IS NOT NULL");
Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Hi Max,
Thank you very much for your help.
I did not understand that it needed a PHP tag, I understood now. Thank you !
The "IS NOT NULL" does not work but "<> ''" works perfectly.
Again thank you and good to you,
Mark.