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 46
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 46
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 = 'kr'
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 = 'kr'
)
) l
|
|
|
Resources:
|
| Browser |
arquivo-web-crawler (compatible; heritrix/3.3.0-SNAPSHOT-2019-08-26T10:34:48Z +http://arquivo.pt) |
| Remote Address |
10.1.232.11 |
| Referrer |
https://eu.shop.bossard.com/group/de/19145/muttern-gewindeeinsaetze/sicherungsmuttern/bn-80175_kombi-sechskantmuttern-mit-unverlierbarer-konischer-scheibe?search_text=twolok |
| Date/Time |
21-Oct-19 08:06 AM |
|