5 Replies Latest reply on Jul 25, 2014 7:58 AM by Dave Ferguson

    Not getting all results in Array Populated from Query

    tchovanec2323

      When running this it is only giving me the last value of my query in the array. Any thoughts on why this is happening? I appreciate any assistance. Thank you

       

      <cfset result = arrayNew(1) />

                 <cfset ArrayMedSchools = structNew() />

               

              <cfloop query="GetMedSchool" >

                   <cfoutput>

                    <cfset ArrayMedSchools.name = Institution />

                    <cfset ArrayMedSchools.id = InstitutionID />

                    <cfset arrayAppend(result,ArrayMedSChools) />

                   </cfoutput>

              </cfloop>

              <cfset ArrayMedSchools = structNew()/>

             

              <cfdump var="#GetMedSchool#" label="Original Query">

              <cfdump var="#result#" label="resulting array">