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 337
Called from D:/web-data/hegibau.ch/http/index.cfm: line 296
Called from D:/web-data/hegibau.ch/http/index.cfm: line 265
Called from D:/web-data/hegibau.ch/http/index.cfm: line 204
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 337
Called from D:/web-data/hegibau.ch/http/index.cfm: line 296
Called from D:/web-data/hegibau.ch/http/index.cfm: line 265
Called from D:/web-data/hegibau.ch/http/index.cfm: line 204
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
|
335 : <cfif f neq "alle" and f neq "offen">
336 : AND medsummary = '#f#'
337 : <cfelseif f neq "alle" and f eq "offen">
338 : AND NOT medsummary IN ('verkauft','reserviert','vermietet')
339 : </cfif>
|
|
VENDORERRORCODE |
306 |
SQLSTATE |
HY000 |
SQL |
SELECT *
FROM tMedia
WHERE medmdcid = 103
AND medstatus <> 99
AND medactiveyn <> 0
AND NOT medsummary IN ('verkauft','reserviert','vermietet')
ORDER BY medsortnr ASC
|
DATASOURCE |
hegibau_cms_cms_sql |
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
54.197.24.206 |
Referrer |
|
Date/Time |
20-Feb-19 10:06 PM |
|