a) surely you need a comma in select URL count(url) as 'visits' --> select URL, count(url) as 'visits' b) You need to add the fields to your group by clause as well. But does it make sense to be grouping by date, which I'm guessing includes hours/minutes/seconds? You might be better to use calculated fields like year(logdate), month(logdate)
Matthew Walker http://www.matthewwalker.net.nz ----- Original Message ----- From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 8:19 AM Subject: select more columns > How do I select more columns from within this query? > > <cfquery name="getsomedata" datasource="log_stats"> > select URL count(url) as 'visits' > from log_data > group by url > order by visits desc > </cfquery> > > I want to get the date and ip columns but get a syntax error when I add the fields after the Select statement as: > > select logdate, ip, URL count(url) as 'visits' > > Thanks. > > Robert O. > HWW > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
