Hi,

I'm trying to create a sql query with the "<" sign, but it won't work. Neither converted in the HTML source of the JCE editor with &lt; nor with &#60; (Article remains empty, without table. Rest of SQL syntax is ok. Works when changing < to =)
How could I achieve a query with those characters? Do I need to change something or does the plugin not convert HTML special chars back to their originals?

Btw. is there a way to output the SQL errors, if any?

Thanks,
mitsm

Hello,

You can switch off WYSIWYG editor and type plugin code in plain text mode or you can use 'ARI Smart Content' module for inserting plugin code and then load module in article with standard 'Content - Load Module' Joomla! plugin or use 3rd party plugin for this purpose, for example JEZ Module Loader.

Regarding SQL errors, you can submit feature request here and we'll 'Debug' option in 'ARI SQL Table' plugin in the next release.

Regards,
ARI Soft