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/genieConnect/iaug/socious2gcEvent.cfm: line 10
Called from d:/server/IntegrationServices/genieconnect/IAUG/socious2gcMaster.cfm: line 9
Called from D:/server/IntegrationServices/genieConnect/iaug/socious2gcEvent.cfm: line 10
Called from d:/server/IntegrationServices/genieconnect/IAUG/socious2gcMaster.cfm: line 9
|
8 :
9 :
10 : <cfquery name="getEventTimes" dbtype="query">
11 : select min(TIMESLOTSTARTDATETIME) as startdatetime ,max(TIMESLOTENDDATETIME) as enddatetime,timeslotstartdate
12 : from attributes.socTimeslots
|
|
EXCEPTIONS |
<small><i>not set</i></small> |
SQL |
select min(TIMESLOTSTARTDATETIME) as startdatetime ,max(TIMESLOTENDDATETIME) as enddatetime,timeslotstartdate
from attributes.socTimeslots
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.119.199 |
Referrer |
|
Date/Time |
23-Apr-24 04:11 PM |
|