Ok, i'm having some problems with the below code.... here's the problem...
in the loop <CFLOOP QUERY="qry_missioncomm"> it is always seeing
qry_missions.mission_id being 1....
if you notice the test code i put in just before it, i see that
qry_missions.mission_id is and check to make sure the previous query has
records... then i set a test variable to qry_missions.mission_id
as such:
<CFOUTPUT>#qry_missions.mission_id#,#qry_missioncomm.recordcount#</CFOUTPUT>
-before<BR>
<CFSET test = qry_missions.mission_id>
so in the 2nd iteration of this loop, i get:
2,9-before
with test being set to 2
now comes the loop:
<CFLOOP QUERY="qry_missioncomm">
followed by:
<CFOUTPUT>#test# should equal #qry_missions.mission_id#</CFOUTPUT>-test<BR>
and wtf??? i get:
2 should equal 1-test
?????????? why isnt the qry_missions.mission_id equal to 2 inside the
second loop??? there are no other declarations here and after the loop,
qry_missions.mission_id is equal to 2....
CODE HERE:
----------------------------------------------------------------------------
-----------------------------------------------------------
<CFQUERY NAME="qry_missions" DATASOURCE="#request.mainDSN#">
SELECT *
FROM tbl_mission
WHERE mission_id <> 0
</CFQUERY>
<CFLOOP QUERY="qry_missions">
<CFQUERY NAME="qry_missioncomm" DATASOURCE="#request.mainDSN#">
SELECT *
FROM tbl_node
WHERE node_id IN
(
SELECT node_id
FROM tbl_mission_comm
WHERE mission_id = #qry_missions.mission_id#
)
</CFQUERY>
<CFOUTPUT>#qry_missions.mission_id#,#qry_missioncomm.recordcount#</CFOUTPUT>
-before<BR>
<CFSET test = qry_missions.mission_id>
<CFLOOP QUERY="qry_missioncomm">
<CFOUTPUT>#test# should equal
#qry_missions.mission_id#</CFOUTPUT>-test<BR>
<CFQUERY NAME="qry_missionq" DATASOURCE="#request.mainDSN#">
SELECT *
FROM tbl_question
WHERE q_node = #qry_missioncomm.node_id#
AND q_mission = #qry_missions.mission_id#
AND q_deleted = 0
</CFQUERY>
<CFOUTPUT>#qry_missioncomm.node_id#-node
#qry_missions.mission_id#-mission</CFOUTPUT><BR>
</CFLOOP>
</CFLOOP>
Terry Bader
IT/Web Specialist
Macromedia Certified Coldfusion Developer
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
