Cannot branch within a find()?

Classic Servoy
1

I had to substitute an sql search for a find()…search() as follows:

forms.student_service_incl_1.controller.find();
forms.student_service_incl_1.svc_student_id = std_student_id;
forms.student_service_incl_1.svc_assessment_id = “^”;
if(drop_D) {
forms.student_service_incl_1.svc_drop_d >= drop_D;
} else {
// in this case don’t exclude any records
}
var recs = forms.student_service_incl_1.controller.search();

…is this because it’s not possible to have conditional branches within a Servoy find()?

Thanks,
Don

2

This won’t work:

djlapin:
forms.student_service_incl_1.svc_drop_d >= drop_D;

[/quote]

The correct syntax is:

forms.student_service_incl_1.svc_drop_d = '>='+ drop_D;
3

Thank you, Nicola, I don’t think I would have found that! - Don