RE: conditional statements with a cfouput group

[Olive, Christopher M Mr USACHPPM]

that's not correct.  use one grouping per level of CFOUTPUT.

ex.

<CFOUTPUT QUERY="fred" GROUP="CITY">
...
<CFOUTPUT GROUP="lastname">
...
</CFOUTPUT>
</CFOUTPUT>

you are correct in that both columns need to appear in the GROUP BY clause
of the SQL statement.

Chris Olive
DOHRS Website Administrator


-----Original Message-----
From: Christopher P. Maher [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 4:23 PM
To: [EMAIL PROTECTED]
Subject: RE: conditional statements with a cfouput group


I didn't follow all of this, but if you are going to next grouping in
CFOutput, you have to have the first grouping include both fields:

Group="city,lastname" for the first cfoutput

Group="lastname" for the second.

Also, be sure you have sorted the query records by City, LastName

I don't usually use CFOutput to group. Rather I use CFLoop and control my
grouping by setting and comparing variables.

Chris

---------------------------------------------------
Christopher P. Maher
mailto:[EMAIL PROTECTED]
Maher Associates, Inc.
Actuarial and Computer Consulting
http://www.maherassociates.com


> -----Original Message-----
> From: Shane Witbeck [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 08, 2000 12:31 PM
> To: [EMAIL PROTECTED]
> Subject: conditional statements with a cfouput group
>
>
> I am trying to filter each record within a cfouput group. Is
> there a way to
> exclude a portion of code from within a cfouput group. The problem I am
> running into is records are being grouped together despite
> conditional code
> I have placed within the grouped cfoutput tag.
>
> What is happening now is any record in the beginning of the grouped output
> pulls in other records that are not suppose to be displayed
> according to the
> conditional date statement as shown below in the pseudocode.
>
> Any alternative suggestions on how to accomplish this would be great.
>
>
>
> This is the current pseudocode:
>
> cfquery for the whole record set
>
> cfoutput group=city
>
> cfif 3 fields containing date attributes are null
> cfset expdate=createdate(3 fields)
> /cfif
>
> cfif datecompare(expdate, now()) is 1
>
> code to display city header
>
> cfouput group=lastname
>
> rest of code for each record detail
>
> </cfoutput>
> </cfif
> </cfoutput>
>
> The current output is correct but is not displaying the correct records
> according to the date criteria.
>
> city
>   lastname
>    records
>
> next city
>   lastname
>    records
> ...
>

----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.