Linux SQL syntax Problem
Posted: Mon 18 Jan 2021 12:05
Hello, I'm getting an error in the sql below. but there is no problem on the windows side. I got the log below from dbmonitor.
SQL;
select *,(case pin when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as pins,(case timerule when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as time
from company_call_rules u where status=:p_status and deleted=:p_deleted and companyid=:p_companyid
Parameters;
p_status WideString[1] '1'
p_deletes WideString[1] '0'
p_companyid Byte 12
Error;
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? '1'nd deleted=? '0'nd companyid=?12' at line 2
SQL;
select *,(case pin when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as pins,(case timerule when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as time
from company_call_rules u where status=:p_status and deleted=:p_deleted and companyid=:p_companyid
Parameters;
p_status WideString[1] '1'
p_deletes WideString[1] '0'
p_companyid Byte 12
Error;
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? '1'nd deleted=? '0'nd companyid=?12' at line 2