Error in Custom View looking for dates

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
eayvl
User
Posts: 315

Error in Custom View looking for dates

Post by eayvl »

Hi,i have a "Custom View" when do the search shows this error.

PHPMaker v2017.0.7

Failed to execute SQL. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[corp_fmto_detalle].[corp_2_cliente] = 4 LIMIT 0, 20' at line 1

search by dates:
Failed to execute SQL. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[corp_fmto_detalle].[corp_2_fechahora] BETWEEN '2018-01-01' AND '2018-01-31' LIM' at line 1

Thanks.


mobhar
User
Posts: 11660

Post by mobhar »

Change [ and ] to ` character respectively.


eayvl
User
Posts: 315

Post by eayvl »

mobhar wrote:
Change [ and ] to ` character respectively.

This change where it applies in phpmaker or in a file *.php


arbei
User
Posts: 9286

Post by arbei »

eayvl wrote:
mobhar wrote:
Change [ and ] to ` character respectively.

This change where it applies in phpmaker or in a file *.php

I think he is talking about to change the [ and ] to ` character in your SQL.


Post Reply