well, that loop will display the first value of query_a.field_a for every row of query_b. then the second value of queryy_a.field_a, and so on. somehow i don't think that's what you want. :) Chris Olive, DOEHRS Website Administrator -----Original Message----- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 2:46 AM To: [EMAIL PROTECTED] Subject: 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 ? Thanks, Roger ---------------------------------------------------------------------------- -- 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.
