}
private int doGetRemoteClientTasks(railo.runtime.type.Query qry, SpoolerTask[] tasks, int row) {
SpoolerTask task;
for(int i=0;i<tasks.length;i++) {
row++;
task=tasks[i];
try{
qry.setAt("type", row, task.getType());
qry.setAt("name", row, task.subject());
qry.setAt("detail", row, task.detail());
qry.setAt("id", row, task.getId());
qry.setAt("lastExecution", row,new DateTimeImpl(pageContext,task.lastExecution(),true));
qry.setAt("nextExecution", row,new DateTimeImpl(pageContext,task.nextExecution(),true));
qry.setAt("closed", row,Caster.toBoolean(task.closed()));
qry.setAt("tries", row,Caster.toDouble(task.tries()));
qry.setAt("triesmax", row,Caster.toDouble(task.tries()));
qry.setAt("exceptions", row,translateTime(task.getExceptions()));
int triesMax=0;
ExecutionPlan[] plans = task.getPlans();
for(int y=0;y<plans.length;y++) {
triesMax+=plans[y].getTries();
}
qry.setAt("triesmax", row,Caster.toDouble(triesMax));
}