Can someone point out why this query is only getting the last group of
records?
A second set of eyes would really help!
If the query qGroups returns the following eventtypes: ItemA, ItemB, ItemC
Only group ItemC and records that are in ItemC will print out.
------------------------------
<CFQUERY NAME="qGroups" DATASOURCE="Events">
SELECT DISTINCT EventType
FROM Events
</CFQUERY>
<CFOUTPUT QUERY="qGroups">
<CFQUERY NAME="qSpecificLocations" DATASOURCE="Events">
SELECT EventID,EventType,X,Y,EventText
FROM Events
WHERE EventType = '#qGroups.EventType#'
</CFQUERY>
<CFIF IsDefined("qSpecificLocations.RecordCount") AND
qSpecificLocations.RecordCount GTE 1>
<CFLOOP QUERY="qSpecificLocations">
#qGroups.CurrentRow#,#qSpecificLocations.CurrentRow#,#qSpecificLocations.X#,
#qSpecificLocations.Y#);
</CFLOOP>
</CFIF>
</CFOUTPUT>
------------------------------
Thanks,
Dave
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
