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/apra/socious2gcEvent.cfm: line 9
Called from d:/server/IntegrationServices/genieconnect/APRA/socious2gcMaster.cfm: line 4
Called from D:/server/IntegrationServices/genieConnect/apra/socious2gcEvent.cfm: line 9
Called from d:/server/IntegrationServices/genieconnect/APRA/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 |
claudebot |
Remote Address |
44.202.209.105 |
Referrer |
|
Date/Time |
29-Mar-24 02:27 AM |
|