I have a dilemma.
I thought I could use this syntax: <cfloop query="getrecord"> to loop
through the oracle query in a sp, but the loop doesn't seem to be
iterating... however, when I do a cfdump of getrecord it properly shows
me all ten records in the query result set.
The cfloop iterates ten times (reflecting the correct number of
records in the result set) and the RecordCount returns 10, but i'm
only seeing the value of the first record repeated ten times.
<cfstoredproc datasource="#request.dsn#" procedure="#request.proc#"
blockfactor="50">
<cfprocparam type="in" value="#spp_BCM_ID#" dbvarname="bcmid"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#spp_rec_type#" dbvarname="rectype"
cfsqltype="cf_sql_integer">
<cfprocparam type="in" value="#spp_fy#" dbvarname="fy"
cfsqltype="cf_sql_integer">
<cfprocresult name="getrecord"/>
</cfstoredproc>
<!-- This shows all records correctly in the result set -->
<cfdump var="#getrecord#">
<!-- This loops RecordCount times, but keeps showing only the values
from the first record -->
<cfloop query="getrecord">
<cfoutput>#getrecord.REC_IDX#
</cfloop>
Anyone got any ideas?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "Houston ColdFusion
Users' Group" discussion list.
To unsubscribe, send email to [EMAIL PROTECTED]
For more options, visit http://groups.google.com/group/houcfug?hl=en
-~----------~----~----~----~------~----~------~--~---
