This has always been the behavior of CF. I can agree that it at first
glances appears to be counter intuitive, but at the same time, any reference
to queryname.fieldname outside the context of a <CFLOOP> or <CFOUTPUT>
results in a reference to the value of the field in the first row of the
query. The functionality is such that there is no "inheritance" of
references.
Since CF5 is feature complete and in RC testing, I would seriously doubt
that a change in behavior is going to happen in this release, or for that
matter even in NEO.
DC
----- Original Message -----
From: "Terry Bader" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 12:36
Subject: RE: [cold_fusion] Unusual Results, help
> well, i got some feedback from the yahoo group and i had to use a variable
> which was set before entering the inner loop...
>
> hope you MM folks got this on the plate for CF5... very frustrating....
>
>
> 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
>
>
>
>
>
> > -----Original Message-----
> > From: Terry Bader [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 03, 2001 10:26 AM
> > To: Cf-Talk (E-mail); HRCF user group (E-mail); ColdFusion -
> > Yahoo Group
> > (E-mail)
> > Subject: [cold_fusion] Unusual Results, help
> >
> >
> > 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.recordcou
> > nt#</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.recordcou
> > nt#</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
> >
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
