PHsPeed forum
Additional spaces added to SQL Sentences that includes "greater than equal" sign or functions names.
-
Hi,
I'm using PHsPeed 1.3.0 B9 - x64, PHP 7.4.5, standard included XAMPP server.
When I set the SQL property of a cDBQuery or a cDBSimpleQuery to a query that contains the "<=" sign, a space is introduced between the "<" and the "=". If the query includes some function names like "trim", a space is added between the function name and the first parenthesis.
STEPS TO REPRODUCE:
Set the sql property of a cDBQuery or a cDBSimpleQuery to any of the following queries:select if(1 <= 2,'this universe','a parallel one') as valor
select trim( 'my string' ) as hileraSave it and then edit it again. A space is now between "<" and "=" or between "trim" and the "(". That leads to runtime errors.
-
