Notice: Undefined index: scenario in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getLatestJournal.php on line 9
Error in executing query. SELECT
TOP 1 RECID, CONVERT(varchar(20),
DATEADD(
HOUR,
CAST (
sales.HORAENTREGAREPARTIDOR AS DECIMAL (12, 4)
) / 3600,
sales.fechaentregarepartidor
), 20) AS 'DATE'
FROM
salesshippingstat sales
WHERE
(sales.snentfact != '') AND DATAAREAID= ORDER BY RECID DESCArray
(
[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 'ORDER'.
[message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'ORDER'.
)
)