Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
|
|
The error occurred in D:/home/dornaco.com/wwwroot/_CFC/ProductTechnicalDate.cfc: line 18
Called from D:/home/dornaco.com/wwwroot/Technical/main.cfm: line 10
Called from D:/home/dornaco.com/wwwroot/Technical/EN/index.cfm: line 5
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from D:/home/dornaco.com/wwwroot/_CFC/ProductTechnicalDate.cfc: line 18
Called from D:/home/dornaco.com/wwwroot/Technical/main.cfm: line 10
Called from D:/home/dornaco.com/wwwroot/Technical/EN/index.cfm: line 5
|
16 :
17 : <cfif TSID IS NOT "">
18 : and TIID in (Select TIID from tbl_TechnicalItem where TSID='#TSID#')
19 : </cfif>
20 : ) order by Priority
|
|
SQLSTATE |
HY000 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
DornacoUnicode |
VENDORERRORCODE |
156 |
SQL |
select * from (
select *,(select Priority from tbl_TechnicalItem where TIID=x.TIID) as Priority,
(Select TitleEN from tbl_TechnicalItem where TIID=x.TIID) as TechnicalItemTitleEN,
(Select TitleFA from tbl_TechnicalItem where TIID=x.TIID) as TechnicalItemTitleFA
from tbl_ProductTechnicalData x
where 1=1
and PrID='8EB07F85110964476D54A914371363A8'
and TIID in (Select TIID from tbl_TechnicalItem where TSID='DRU')
) order by Priority |
|
Resources:
|
Browser |
claudebot |
Remote Address |
100.26.1.130 |
Referrer |
|
Date/Time |
29-Mar-24 06:22 AM |
|