How do you process this..

I'm not sure how you loop through this structure.

Oracle SQL (create the types within an SQL window)

create type studentMatch as object (federalIdNumber varchar2(9),
studentNumber varchar2(11),
lastName varchar2(30),
firstName varchar2(30),
middleName varchar2(30),
birthDate date,
gender varchar2(1));

create type studentMatchType as table of studentMatch;

create type studentMatchObject as object (students studentMatchType);

Query:

select studentMatchObject(cast(multiset((select federal_id_number,
student_number,
last_name,
first_name,
middle_name,
birth_date,
gender
from student_info b
where b.federal_id_number = a.federal_id_number))
as studentMatchType)),
b.federal_id_number,
b.last_name
from students

That query is wrapped within a <cfquery name="studentLoop"> statement.

So, how do I loop through the studentMatchType object? Would it be something like:

<cfloop query="studentLoop">
#studentMatchType.federal_id_number# (is that how you do it?)
#studentMatchType.last_name#
</cfloop>