Error Executing Database Query.
|
Query Of Queries runtime error.
The select column reference [TIMESLOTSTARTDATETIME] is not a column in any of the tables of the FROM table list.
|
|
The error occurred in D:/server/IntegrationServices/insight/genieConnect/socious2gcEvent.cfm: line 9
Called from d:/server/IntegrationServices/INSIGHT/genieconnect/socious2gcMaster.cfm: line 4
Called from D:/server/IntegrationServices/insight/genieConnect/socious2gcEvent.cfm: line 9
Called from d:/server/IntegrationServices/INSIGHT/genieconnect/socious2gcMaster.cfm: line 4
|
7 :
8 :
9 : <cfquery name="getEventTimes" dbtype="query">
10 : select min(TIMESLOTSTARTDATETIME) as startdatetime ,max(TIMESLOTENDDATETIME) as enddatetime,timeslotstartdate
11 : from attributes.socSessions
|
|
EXCEPTIONS |
<small><i>not set</i></small> |
SQL |
select min(TIMESLOTSTARTDATETIME) as startdatetime ,max(TIMESLOTENDDATETIME) as enddatetime,timeslotstartdate
from attributes.socSessions
group by timeslotstartdate order by startdatetime,enddatetime |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.217.4.206 |
Referrer |
|
Date/Time |
25-Apr-24 11:43 AM |
|