Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
|
|
The error occurred in D:/web-data/hegibau.ch/http/index.cfm: line 350
Called from D:/web-data/hegibau.ch/http/index.cfm: line 309
Called from D:/web-data/hegibau.ch/http/index.cfm: line 278
Called from D:/web-data/hegibau.ch/http/index.cfm: line 217
Called from D:/web-data/hegibau.ch/http/index.cfm: line 1
Called from D:/web-data/hegibau.ch/http/pages/mod/400.cfm: line 70
Called from D:/web-data/hegibau.ch/http/index.cfm: line 350
Called from D:/web-data/hegibau.ch/http/index.cfm: line 309
Called from D:/web-data/hegibau.ch/http/index.cfm: line 278
Called from D:/web-data/hegibau.ch/http/index.cfm: line 217
Called from D:/web-data/hegibau.ch/http/index.cfm: line 1
Called from D:/web-data/hegibau.ch/http/pages/mod/400.cfm: line 70
|
348 : <cfif f neq "alle" and f neq "offen">
349 : AND medsummary = '#f#'
350 : <cfelseif f neq "alle" and f eq "offen">
351 : AND NOT medsummary IN ('verkauft','reserviert','vermietet')
352 : </cfif>
|
|
VENDORERRORCODE |
306 |
SQLSTATE |
HY000 |
SQL |
SELECT *
FROM tMedia
WHERE medmdcid = 150
AND medstatus <> 99
AND medactiveyn <> 0
AND medsummary = 'vermietet'
ORDER BY medsortnr ASC
|
DATASOURCE |
hegibau_cms_cms_sql |
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
34.237.124.210 |
Referrer |
|
Date/Time |
24-Feb-21 06:36 PM |
|