Notice: Undefined index: journal in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getDeliveryGuy.php on line 8
Notice: Undefined index: scenario in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getDeliveryGuy.php on line 9
Error in executing query. SELECT sales.repartidor AS Repartidor FROM salesshippingstat sales INNER JOIN salesshippingjour ON sales.snentfact = salesshippingjour.snentfact AND sales.dataareaid = salesshippingjour.dataareaid INNER JOIN salestable ON sales.salesid = salestable.salesid AND sales.dataareaid = salestable.dataareaid INNER JOIN custtable ON salestable.invoiceaccount = custtable.accountnum AND salestable.dataareaid = custtable.dataareaid WHERE sales.snentfact = and sales.dataareaid= AND ( sales.snentfact != '' ) AND ( salesshippingjour.fechaenvio > DATEADD(day, -5, GETDATE()))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'.
)
)