Hi,
That's what I'm facing right now, apparently I do not understand why is it
so. Under your example, for the second time it looped, why the Second Loop
show "John" and not "Smith"?
I tried to use the following method to solve this problem:
<cfloop query="query_a">
<cfoutput>#query_a.field_a#<cfoutput>
<cfset display_a = #query_a.field_a#>
<cfloop query="query_b">
<cfoutput>#variables.display_a#<cfoutput>
</cfloop>
</cfloop>
In that case, the second loop will follow the result of that in the first
loop. What do you think?
Roger
----- Original Message -----
From: "Sima Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 2:18 AM
Subject: Re: Multiple <CFLOOP>s
> Hi, the inner loop should always print out " 1". Because in the inner loop
> you loop through the second query not the first one and it simply excute
the
> statement : <cfoutput>#query_a.field_a#<cfoutput> as many time as the
second
> query's recordcount.
> I have an example here:
>
> <cfset Customer =
>
Querynew("SenderName,RecipientName,Subject,SenderEmail,RecipientEmail,Messag
> e")>
>
> <cfset TempCust = QueryAddRow(Customer)>
>
>
> <cfset TempCust = QuerySetCell(Customer, "SenderName", "John")>
> <cfset TempCust = QuerySetCell(Customer, "RecipientName"," Mary")>
> <cfset TempCust = QuerySetCell(Customer, "Subject", "Dinner")>
> <cfset TempCust = QuerySetCell(Customer, "SenderEmail",
"[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(Customer, "RecipientEmail",
> "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(Customer, "Message", "arange a dinner
> together")>
>
> <cfset TempCust = QueryAddRow(Customer)>
>
>
> <cfset TempCust = QuerySetCell(Customer, "SenderName", "Smith")>
> <cfset TempCust = QuerySetCell(Customer, "RecipientName"," Black")>
> <cfset TempCust = QuerySetCell(Customer, "Subject", "Dinner")>
> <cfset TempCust = QuerySetCell(Customer, "SenderEmail",
"[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(Customer, "RecipientEmail",
> "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(Customer, "Message", "arange a dinner
> together")>
>
>
> <cfset
>
cftalk=QueryNew("SenderName,RecipientName,Subject,SenderEmail,RecipientEmail
> ,Message")>
>
> <cfset TempCust = QueryAddRow(cftalk)>
>
>
> <cfset TempCust = QuerySetCell(cftalk, "SenderName", "John")>
> <cfset TempCust = QuerySetCell(cftalk, "RecipientName"," Mary")>
> <cfset TempCust = QuerySetCell(cftalk, "Subject", "Dinner")>
> <cfset TempCust = QuerySetCell(cftalk, "SenderEmail", "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(cftalk, "RecipientEmail",
> "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(cftalk, "Message", "arange a dinner
> together")>
>
> <cfset TempCust = QueryAddRow(cftalk)>
>
>
> <cfset TempCust = QuerySetCell(cftalk, "SenderName", "Smith")>
> <cfset TempCust = QuerySetCell(cftalk, "RecipientName"," Black")>
> <cfset TempCust = QuerySetCell(cftalk, "Subject", "Dinner")>
> <cfset TempCust = QuerySetCell(cftalk, "SenderEmail", "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(cftalk, "RecipientEmail",
> "[EMAIL PROTECTED]")>
> <cfset TempCust = QuerySetCell(cftalk, "Message", "arange a dinner
> together")>
>
>
>
>
> This is the Cftalk example:<br>
> <cfloop query="Customer">
> <cfoutput>Firt loop:#Customer.SenderName#</cfoutput><br>
> <cfloop query="cftalk">
> <cfoutput>Second loop:#Customer.SenderName#</cfoutput><br>
> </cfloop>
> </cfloop>
>
>
> /*The out put:
>
> Firt loop:John
> Second loop:John
> Second loop:John
> Firt loop:Smith
> Second loop:John
> Second loop:John*/
>
>
> Sima
> ----- Original Message -----
> From: Stephen Moretti <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 13, 2000 7:42 AM
> Subject: RE: Multiple <CFLOOP>s
>
>
> > >
> > > I have 2 queries which require to loop through for certain execution.
> > > However I discovered something
> > >
> > > <cfloop query="query_a">
> > > <cfoutput>#query_a.field_a#<cfoutput>
> > > <cfloop query="query_b">
> > > <cfoutput>#query_a.field_a#<cfoutput>
> > > </cfloop>
> > > </cfloop>
> > >
> > > I realised that both #query_a.field_a# are different values, for the
> first
> > > one, it is able to list out all the different values. However for
> > > the second
> > > one, it only output the first value throughout.
> > >
> > > Is it something to do with multiple <cfloop>s ?
> > >
> > > Can somebody enlighten me on this ?
> > >
> >
> > Eh....
> >
> > OK - if you get this result set from your query a and query b :
> >
> > QueryA QueryB
> > FieldA Yourfield
> > 1 a
> > 2 b
> > 3 c
> >
> > What you're going to get output is this:
> > * 1
> > 1
> > 1
> > 1
> > * 2
> > 2
> > 2
> > 2
> > * 3
> > 3
> > 3
> > 3
> >
> > The rows marked with a * are displayed in the outer loop and the other
are
> > displayed in the inner loop.
> >
> > The reason for this is that your inner loop is only going to loop round
> the
> > contents of QueryB and output the _current row_ from QueryA. On the
first
> > iteration of the loop on QueryA the displayed result is "1", then the
> inner
> > loop iterates through QueryB, but doesn't move onto the next record in
> > QueryA. This means that for every iteration of QueryB on the first time
> > round the QueryA loop you'll only get the result "1".
> >
> > Are you sure that you have specified your code snippet correctly and is
> > there something else that you are doing in the loop that is missing from
> the
> > above snippet???
> >
> > Regards
> >
> > Stephen
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > 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.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
