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.
