Hi, I just installed Data Tables in Joomla 3.02 and have a problem with a very simple query. I use ARI Data Table with jquery UI theme (local copy, no conflict).
1) Data base contains only plain text fields (sometimes a sentence with commas) and ID. With ORDER BY 'XYZ' ASC written in the SQL query field some field entries appear in other fields than expected. In some cases entries are drawn from an invisible=not selected field. In some fields text is suddenly cut off, sometimes before an umlaut. The database apparently looks good in phpMyAdmin!
Are TRIM or other sql code snippets necessary to sort this out?
When I omit ORDER BY in the SQL query field and use the GUI instead, the same happens.
2) Table sorting is either switched on or off completely, I'm not able switch it individually for single columns in the settings.
Attached 2 screenshots from phpMyAdmin and browser view of the same database.
What am I doing wrong? Unfortunately, I'm only web designer, no php coder
I would appreciate very much some helpful advice, thx in advance!
