-> From variables.asp works on initial load
SELECT DB_DeviceInfoEx.Updatetime,DB_DeviceInfoEx.ProductName, DB_DeviceInfoEx.TotalMemory, DB_DeviceInfoEx.SerialNumber, DB_DeviceInfoEx.ROMVersion, DB_DeviceInfoEx.OSName, DB_DeviceInfoEx.OSVersion, DB_DeviceInfoEx.OSDescription, devicenames.nameSNMP FROM DB_DeviceInfoEx LEFT JOIN deviceNames ON DB_DeviceInfoEx.DeviceKey = deviceNames.DeviceKey;
-> From DB_DeviceInfoEx_list.asp AFTER column is selected to sort OR manual search parameters are added
2147217900
Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'order'.
URL /cim/DB_DeviceInfoEx_list.asp
SQL query SELECT DB_DeviceInfoEx.Updatetime,DB_DeviceInfoEx.ProductName, DB_DeviceInfoEx.TotalMemory, DB_DeviceInfoEx.SerialNumber, DB_DeviceInfoEx.ROMVersion, DB_DeviceInfoEx.OSName, DB_DeviceInfoEx.OSVersion, DB_DeviceInfoEx.OSDescription, devicenames.nameSNMP FROM DB_DeviceInfoEx LEFT JOIN deviceNames ON DB_DeviceInfoEx.DeviceKey = deviceNames.DeviceKey; order by OSName asc