Notice: Undefined index: start in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollectByCode.php on line 8
Notice: Undefined index: stop in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollectByCode.php on line 9
Notice: Undefined index: scenario in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollectByCode.php on line 10
Notice: Undefined index: IDCode in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollectByCode.php on line 11
Error in executing query. SELECT CAST(SUM(AMOUNTCUR) as DECIMAL) as 'AMOUNT' FROM dbo.CUSTTRANS trans INNER JOIN dbo.custtable cust ON cust.dataareaid = trans.dataareaid AND trans.ACCOUNTNUM = cust.ACCOUNTNUM
WHERE TRANSDATE BETWEEN AND and VOUCHER LIKE 'RB%' AND trans.ACCOUNTNUM = AND trans.DATAAREAID=Array
(
[0] => Array
(
[0] => 42000
[SQLSTATE] => 42000
[1] => 156
[code] => 156
[2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
[message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
)
)