7 Replies Latest reply on Jan 30, 2017 3:03 PM by rgordon

    Help with execute sql

    rgordon

      I have a check box field with five values (apples, bananas, grapes, pears and oranges) and  a class field with 3 values (101, 102, and 103). Multiple fruit can be selected but only 1 class can be selected. I know how to do an execute sql to get the count of one fruit but I'm having trouble getting the total count of all fruit in one execute sql statement. Ideally it would be nice to be able to also return an array with class by fruit.  I can get the results I want with multiple execute Sql statement but would prefer to do it with one. Any help with this would be greatly appreciated.