Cfgrid question

[Occy]

I would like to use the cfgrid, but i am having some problems.

For example, if i have 2 tables: employee and results. Employee has Employee_ID, employee_name, employee_address, employee_phone and Results have employee_id, results_1 ... results_n.

I have the following query:

<cfquery name = &quot;GetResults&quot; . . .>
select * from employee, results
from employee, results
where employee.employee_id = Results.employee_id;
</cfquery>

In my grid from the employee table all I want to display is the employee_name (hide the rest of the fields, which i know how to do) but the problem comes in when i try to display the results_1 .. results_n. I don't know how many results will be returned, and i only want to show the results.

Is this possible? I will always know what fields I want to hide from the query, but i won't know how many fields to display. I don't want to rename the results_1 to results_n fields, so they can stay as the default name.

Any ideas would be greatly appreciated.
Thanks in advance.