Error Executing Database Query.
|
|
Unknown column 'ndex.cfm' in 'where clause'
|
| |
The error occurred in C:/inetpub/wwwroot/leb.de.internet/system/2/lib_documents.cfm: line 211
Called from C:/inetpub/wwwroot/leb.de.internet/system/2/lib_content.cfm: line 237
Called from C:/inetpub/wwwroot/leb.de.internet/system/2/index.cfm: line 53
Called from C:/inetpub/wwwroot/leb.de.internet/index.cfm: line 3
Called from C:/inetpub/wwwroot/leb.de.internet/system/2/lib_documents.cfm: line 211
Called from C:/inetpub/wwwroot/leb.de.internet/system/2/lib_content.cfm: line 237
Called from C:/inetpub/wwwroot/leb.de.internet/system/2/index.cfm: line 53
Called from C:/inetpub/wwwroot/leb.de.internet/index.cfm: line 3
|
209 : ((tdate_start <= #Now()# or tdate_start is NULL) and (tdate_expire >= #Now()# or tdate_expire is NULL) and isdate = 0)
210 : or
211 : (tdate_start >= #Now()# or tdate_start is NULL or tdate_expire >= #Now()# or tdate_expire is NULL and isdate = 1)
212 : )
213 : limit 0,1
|
|
| VENDORERRORCODE |
1054 |
| SQLSTATE |
42S22 |
| SQL |
select * from tbl_docwork where id = ndex.cfm and used = 1
and (
((tdate_start <= {ts '2012-05-18 10:01:53'} or tdate_start is NULL) and (tdate_expire >= {ts '2012-05-18 10:01:53'} or tdate_expire is NULL) and isdate = 0)
or
(tdate_start >= {ts '2012-05-18 10:01:53'} or tdate_start is NULL or tdate_expire >= {ts '2012-05-18 10:01:53'} or tdate_expire is NULL and isdate = 1)
)
limit 0,1
|
| DATASOURCE |
leb_internet |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.107.179.226 |
| Referrer |
|
| Date/Time |
18-May-12 10:01 AM |
|