Hi
SC8 (8.00.0028) is not able to handle an apostrophe in the following scenarios:
GRID - ADVANCED SEARCH
If I run a grid and search in Quick Search for the string D’AMICO it works perfectly.
But if in the same grid I use Advanced Search to search for the same string, in any field, I get no results and this error:
Error while accessing the database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AMICO’’ at line 1
select distinct nome from view_attivita_full where nome = ‘D’AMICO’
GRID - GROUP BY, THEN SUMMARY
If I run a a grid and dynamically Group By a field where some rows contain an apostrophe, SC execute the group by with no problems.
But when I click on the Summary button (Group By still ‘active’) I get the following line repeated many times at the top of the page, followed by the summary correctly generated only for the rows not containing the apostrophe (i.e. no summary for the rows with apostrophe)
Parse error: syntax error, unexpected ‘AMICO’ (T_STRING), expecting ‘]’ in /opt/NetMake/v8/wwwroot/scriptcase/app/proProectWebEnd/grid_progetti/grid_progetti_total.class.php(249) : eval()'d code on line 2
Maybe NetMake forgot to apply to Advanced Search and Summary the same escape routine that make Quick Search and Group By work