GROUP BY problem...

SELECT employees.empID employees.name, employees_office.theORDER office.office_name areas.area_NAME FROM employees INNER JOIN employees_office ON employees.empID = employees_office.empID INNER JOIN office ON employees_office.id_office = dbo.office.office_id INNER JOIN areas ON

RE: GROUP BY problem...

02, 2009 12:10 PM To: cf-talk Subject: GROUP BY problem... SELECT employees.empID employees.name, employees_office.theORDER office.office_name areas.area_NAME FROM employees INNER JOIN employees_office ON employees.empID = employees_office.empID INNER JOIN office

Re: GROUP BY problem...

Why not just cfoutput query= group=name b#name#/bbr cfoutput #area_name#, #office_name#br /cfoutput /cfoutput On Fri, Oct 2, 2009 at 9:09 AM, Les Mizzell lesm...@bellsouth.net wrote: SELECT employees.empID employees.name,

Re: GROUP BY problem...

Agha Mehdi wrote: Why not just cfoutput query= group=name b#name#/bbr cfoutput #area_name#, #office_name#br /cfoutput /cfoutput I could - but it's way more complicated than that... This single query (example was simplified) is responsible for a

RE: GROUP BY problem...

information. You could make multiple columns address1, address2, etc but that is considered really bad database design and isn't normalized. Steve -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Friday, October 02, 2009 12:58 PM To: cf-talk Subject: Re: GROUP

RE: GROUP BY problem...

Diego (W), New Orleans (S) Is that the kind of result set you are looking for? Dave -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Friday, October 02, 2009 11:10 AM To: cf-talk Subject: GROUP BY problem... SELECT employees.empID employees.name

OT: ASP and GROUP BY problem

Hi list, I want to do a GROUP BY statement in an ASP-Page. In CF I can do something like: cfoutput query=foo1 group=foo2 When I try to do this in ASP included in the SQL-statement I get an aggregate function error. (unfortunately in german, so it doesn't make sense to post). Can s.o. post his

RE: ASP and GROUP BY problem

I want to do a GROUP BY statement in an ASP-Page. In CF I can do something like: cfoutput query=foo1 group=foo2 When I try to do this in ASP included in the SQL-statement I get an aggregate function error. (unfortunately in german, so it doesn't make sense to post). Can s.o. post his

OT: RE: ASP and GROUP BY problem

ASP does not provide a Group By equivalent to what is available in CF. You'll need to either build a VBScript function to do this or build it each time, storing the last value of the Grouped attribute and executing a sequence of code when it changes. Then your query would ORDER BY your grouped

RE: Group by problem in select query

I am selecting 8 fields (one is a count) and I do not want a group by clause. Kathy, You have to have a GROUP BY if you are using COUNT(). It's an aggregate function - that means it's meaningless without a GROUP BY. What are you trying to do? Nick

Re: Group by problem in select query

PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 23, 2000 9:19 AM Subject: Group by problem in select query Is there a way around this error message? I am selecting 8 fields (one is a count) and I do not want a group by clause. Without a group by clause or if I leave one of the