Try a <cfoutput query="getrecord">#getrecord.REC_IDX#<cfoutput> else you would probably need to reference the current row in brackets after REC_IDX with the way you have it currently.
On Nov 30, 2007 3:53 PM, <[EMAIL PROTECTED]> wrote: > > 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? > > > -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
