Hi Roger,
I think the way you found (set a variable in the out loop and output it in
the inner loop) is a simple way to do it.
Regards
Sima
----- Original Message -----
From: Roger Lim <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 9:31 PM
Subject: Re: Multiple <CFLOOP>s
> Hi Sima,
>
> According to your example that you've given me, below is what I want to
> achieve is the following output:
>
> Firt loop:John
> Second loop:John
> Second loop:John
> Firt loop:Smith
> Second loop:Smith
> Second loop:Smith
>
> I just wish to have the inner loop output the follow whatever the output
of
> the outer loop because it suppose to work that way.
>
> Roger
> ----- Original Message -----
> From: "Sima Lee" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, September 14, 2000 9:09 PM
> Subject: Re: Multiple <CFLOOP>s
>
>
> > Hi, Roger,
> >
> > What do you want to achieve? Do you want the inner loop repeat the out
> > loop's output ? Then how many times? This will give you the times EQ to
> the
> > second query's recordcount.
> >
> > Sima
> > ----- Original Message -----
> > From: Roger Lim <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 13, 2000 9:19 PM
> > Subject: Re: Multiple <CFLOOP>s
> >
> >
> > > 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/[email protected]/
> > > > > 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/[email protected]/
> > > > 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/[email protected]/
> > > 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/[email protected]/
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
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.
