Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Select Error in Bil...
 
Notifications
Clear all

Select Error in BillLine.php

2 Posts
2 Users
0 Reactions
2,468 Views
(@antonio-grr)
Posts: 84
Active Member
Topic starter
 
[#3790]

Hi.
In BillLine.php the lines

$crit.=" and workDate>="".$this->startDate.""";
$crit.=" and workDateendDate.""";

in function save and in function delete use double quote for date values. This is not allowed by postgres.
The same query fails when you do not enter start/ end date in form, as query is executed before validating mandatory field.
I fixed in this way

if ($this->startDate) $crit.=" and workDate>'" . $this->startDate . "'";
if ($this->endDate) $crit.=" and workDateendDate . "'";
Best regards


 
Posted : 26 Oct 2016 18H32
(@babynus)
Posts: 14952
Member Admin
 

Thanks for the fix.
It will be included in next version.


 
Posted : 26 Oct 2016 19H31
Share:

Scroll to Top