Not getting all results in Array Populated from Query
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">