I am currently trying to develop a module for XOOPS, and found some strange behaviour in the CriteriaElement and related classes. Maybe somebody could help or let me know if I am using them in the wrong way.

First I found that when you do the following:



the render of the WHERE clause is not correctly formatted and it ends up with:



instead of:



It basically means that we cannot look for an empty string in a table.

Furthermore, I have try to use the CriteriaElement objects to look for NULL columns in the database, and it does not work too. If I do:



the same happen.

It looks like the two problems are coming from the following lines in the Criteria::render() function:



Is it intentional? How can I look for an empty column using the CriteriCompo object?

Same questions for the NULL columns? For this one, I had to add the following lines at the beginning of the Criteria::render() function:



Thanks for your help.

BTW congratulation to the XOOPS team! XOOPS is great, I love it.

would this work?
$criteria->add(new Criteria('text1', 'NULL');

No, it did not.

If I have a column as type INT and perform the following querry:



nothing is returned, but if I do:



It returns all the rows where I have this column set as NULL. The problem is that the Criteria class automatically adds the quotes.

For a varchar column it looks like you cannot look for a NULL value but you have to look for an empty string (but I cannot use it with XOOPS as explain before).

Thanks.

If your little hack works as it should, do submit it to the Patches Tracker

Sounds like it could be useful.

I will.

Thanks.