How to read from 2 queries

May i know how to read from 2 queries?

For example, I have use

<cfoutput query="FindCountry">
<cfoutput query="FindNationality">
The country is #FindCountry.id#
The nationality is #FindNationality.id#
</cfoutput>
</cfoutput>

I was prompted an error when i do this.

Thanks

 

Get rid of the second <cfoutput>. Why because you are already 'outputting'. You only now need to loop. Hence your code should instead be:
<cfoutput query="FindCountry">
<cfloop query="FindNationality">
The country is #FindCountry.id# and
The nationality is #FindNationality.id# <br />
</cfloop>
</cfoutput>

Hope I helped

DaTropics!

 

What if you wanted to loop through both of the queries?

 

with the code above, you already are. What are you trying to do?