This has got to be in the FAQ. By the way, where's the FAQ?
To cut from a similar answer a few days ago:
My understanding is that you can only run through one query at a time (with CF
handling the currentRow your on.)
So you are going to want to only rely on the query= for one of your two loops. Or
maybe none.
This is not the only way, but it should work.
Other people will chime in with the correct (and faster) ways, but this should get
you going.
<cfoutput>
<cfloop index="cRow" from="1" to="#SecondQuery.recordCount#" step="1">
#SecondQuery['RowName'][cRow]#
<cfloop index="cRow2" from="1" to="#first.recordCount#" step="1">
#SecondQuery['RowName'][cRow]#
#first['RowName'][cRow2]#
</cfloop>
</cfoutput>
If this doesn't help, shout out and I'll try a more specific answer.
Jerry Johnson
>>> [EMAIL PROTECTED] 04/16/02 02:29PM >>>
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
______________________________________________________________________
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
