[<daniel.a.fulton@delphiauto.com>]
I want to use this method in a python script but can't for the life of me
get it
to return the entire result set.
Python script:
results = context.employ_data(month=month, year=year)
for result in results: return result.sum_hour, result.sum_total, result.division
This returns only one record -- the first record in the result set. I need the entire result set.
The "return" statement causes the function to end and return the result. So you only get the first row. You should build the results into a list, then return the list. rows=[] for result in results: rows.append( (result.sum_hour, result.sum_total)) return rows Each row is now a tuple containing the hour and sum. Cheers, Tom P