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.
