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.

Error in Custom View looking for dates

Postby eayvl » Sat Jan 13, 2018 1:08 am

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.
eayvl
 
Posts: 103
Joined: Thu Feb 05, 2015 2:50 am

Re: Error in Custom View looking for dates

Postby mobhar » Sat Jan 13, 2018 11:30 am

Change [ and ] to ` character respectively.
mobhar
 
Posts: 4661
Joined: Wed Jun 05, 2013 2:11 pm

Re: Error in Custom View looking for dates

Postby eayvl » Sun Jan 14, 2018 11:02 am

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

This change where it applies in phpmaker or in a file *.php
eayvl
 
Posts: 103
Joined: Thu Feb 05, 2015 2:50 am

Re: Error in Custom View looking for dates

Postby arbei » Mon Jan 15, 2018 3:22 pm

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.
arbei
 
Posts: 1490
Joined: Wed Sep 09, 2015 10:13 am


Return to General Discussion (PHPMaker)