Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
|
| |
The error occurred in D:/www_live/_framework/_sys_global/_check_UrlStringCode.cfm: line 81
Called from D:/www_live/bossard_eshop/application.cfc: line 43
Called from D:/www_live/bossard_eshop/application.cfc: line 11
Called from D:/www_live/_framework/_sys_global/_check_UrlStringCode.cfm: line 81
Called from D:/www_live/bossard_eshop/application.cfc: line 43
Called from D:/www_live/bossard_eshop/application.cfc: line 11
|
79 : AND T23.ExtendedPath = '#CGI.SCRIPT_NAME.split("/")[2]#'
80 : </cfif>
81 : WHERE T21.Shortcut = '#url.lang#'
82 : )
83 : ) l
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
ShopDB |
| VENDORERRORCODE |
156 |
| SQL |
SELECT LanguageID, SlugTransliteration, IsoCode
FROM (
SELECT t21.LanguageID, t21.SlugTransliteration, t21.IsoCode
FROM BossBoardDB.dbo.Language t21
INNER JOIN Site_Language_Ref T22
ON T21.LanguageID = T22.LanguageID
INNER JOIN Site T23
ON T22.SiteID = T23.SiteID
AND T23.ActiveFlag = 1
AND T23.ExtendedPath = 'group'
WHERE t21.Shortcut = 'cn'
UNION ALL
--
SELECT LanguageID, SlugTransliteration, IsoCode
FROM BossBoardDB.dbo.Language
WHERE LanguageID = AND NOT EXISTS (
SELECT NULL
FROM BossBoardDB.dbo.Language T21
INNER JOIN Site_Language_Ref T22
ON T21.LanguageID = T22.LanguageID
INNER JOIN Site T23
ON T22.SiteID = T23.SiteID
AND T23.ActiveFlag = 1
AND T23.ExtendedPath = 'group'
WHERE T21.Shortcut = 'cn'
)
) l
|
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
10.1.232.11 |
| Referrer |
|
| Date/Time |
01-Mar-21 11:31 PM |
|