Hi Jeffry,
When grouping with cfoutput you need to remember
GROUPCASESENSITIVE="yes/no". By default coldfusion groups by case
sensitivity. Case sensitivity on SQL server depends on the installation.
Even if SQL Server is set up as case-insensitive, cfoutput will use
case-sensitive as the default.
John
----- Original Message -----
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 9:58 AM
Subject: Re: Group By..
> When you use aggregate functions in the SELECT clause to produce summary
> information, you use the GROUP BY clause to divide the information into
> distinct groups. Your database system uses any column or lost of columns
> following the GROUP BY keywords as grouping columns. It is an optional
> clause.
>
> The CFOUTPUT is a way to group output. The GROUP parameter eliminates
> duplicates in the case where data is sorted by the specified fields.
>
>
> ----- Original Message -----
> From: "Jeffry Houser" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, August 24, 2001 11:43 AM
> Subject: Group By..
>
>
> >
> > This is one thing that has always escaped my understanding, and I had
> the
> > sudden urge to ask.
> >
> > What is Group By. How is Group By used? What is it used for? ( both
> in
> > SQL Statements and the group attribute in the CFOUTPUT tag )
> >
> > Anyone want to take a minute and attempt to explain it to me?
> >
> >
> > --
> > Jeffry Houser | mailto:[EMAIL PROTECTED]
> > AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
> > --
> > I'm looking for a room-mate in the Hartford CT area, starting in August
> > --
> > Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
> > http://www.instantcoldfusion.com
> > --
> > DotComIt, LLC
> > database driven web data using ColdFusion, Lotus Notes/Domino
> > --
> > Far Cry Fly, Alternative Folk Rock
> > http://www.farcryfly.com | http://www.mp3.com/FarCryFly
> > --
> > Change is good
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
