cfstoredproc scope issue?
When i try to display
<tr><td id="smNormalText">Country: <strong><cfoutput>#list_all_country_sp_rst.county_name#</cfoutput></strong></td></tr>
i get empty value....it is not displaying Country value coming from procedure
Here is code
<cfstoredproc procedure="list_all_country_sp" datasource="#dsn#" username="#user#" password="#pass#" returncode="yes" debug="yes">
<cfprocresult name="list_all_country_sp_rst">
</cfstoredproc>
<cfloop query="list_all_country_sp_rst">
<cfstoredproc procedure="list_all_state_sp" datasource="#dsn#" username="#user#" password="#pass#" returncode="yes" debug="yes">
<cfprocresult name="list_all_state_sp_rst">
<cfprocparam type="in" cfsqltype="CF_SQL_VARCHAR" variable="county_name_in" value="#list_all_country_sp_rst.county_name#" null="no">
</cfstoredproc>
<cfloop query="list_all_state_sp_rst">
<cfstoredproc procedure="name_count_sp" datasource="#dsn#" username="#user#" password="#pass#" returncode="yes" debug="yes">
<cfprocparam type="in" cfsqltype="CF_SQL_VARCHAR" variable="state_name_in" value="#list_all_state_sp_rst.state_name#" null="no">
<cfprocresult name="name_count_sp_rst">
</cfstoredproc>
<cfif name_count_sp_rst.name_count neq '0'>
<tr><td id="smNormalText">Country: <strong><cfoutput>#list_all_country_sp_rst.county_name#</cfoutput></strong></td></tr>
<tr><td id="smNormalText">State: <strong><cfoutput>#list_all_state_sp_rst.state_name#</cfoutput></strong></td></tr>
</cfloop>
</cfloop>
