Error Executing Database Query.
|
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cmsc.ClubInfo.OurKey' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
|
|
The error occurred in C:/inetpub/vhosts/skiandrideclubguide.com/skicmsc.com/Report_ClubsPublic.cfm: line 87
|
85 : </cfif>
86 :
87 : <cfquery name="Populate_club" datasource="TM_jdbc">
88 : select * from ClubInfo where inactive <> "Yes" and trim(clubid) <> "" group by ClubName order by ClubName
89 : </cfquery>
|
|
SQLSTATE |
42000 |
DATASOURCE |
TM_jdbc |
VENDORERRORCODE |
1055 |
SQL |
select * from ClubInfo where inactive <> "Yes" and trim(clubid) <> "" group by ClubName order by ClubName
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
52.87.200.112 |
Referrer |
http://www.skicmsc.com/Report_ClubsPublic.cfm?sortby=AuthPersonLN&MeetingCity=All&MeetingState=All&ClubeMail=&ClubName=all&FirstTime=N |
Date/Time |
29-Mar-24 08:40 AM |
|