| Category: |
Microsoft OLE DB Provider for ODBC Drivers |
| ASPCode: |
|
| ASPDescription: |
|
| Number: |
-2147217900 |
| Description: |
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'order'. |
| File: |
/product_mp.asp |
| Source: |
|
| Column: |
-1 |
| Line: |
49 |
| errorSQL: |
update we_ItemsSiteReady set inv_qty = (select top 1 b.inv_qty from we_Items a left join we_Items b on a.PartNumber = b.PartNumber and b.master = 1 where a.itemID = order by b.inv_qty desc) where itemID = |
| errorSQL2: |
|