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/idug/genieConnect/socious2gcEvent.cfm: line 13
Called from d:/server/IntegrationServices/idug/genieConnect/socious2gcMaster.cfm: line 4
Called from D:/server/IntegrationServices/idug/genieConnect/socious2gcEvent.cfm: line 13
Called from d:/server/IntegrationServices/idug/genieConnect/socious2gcMaster.cfm: line 4
|
11 :
12 :
13 : <cfquery name="getEventTimes" dbtype="query">
14 : select min(TIMESLOTSTARTDATETIME) as startdatetime ,max(TIMESLOTENDDATETIME) as enddatetime,timeslotstartdate
15 : 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 |
3.145.191.214 |
Referrer |
|
Date/Time |
20-Apr-24 05:40 AM |
|