celamar

Because the following syntax does not function? Code: parameters.put("param1", request.getParameter("param1"«»)+" AND YEAR=2006"«»); I want to add this SQL to the end of parametro in determined situation. How I make? It forgives for the English, I am Brazilian

With the son it gave certain. With the father it does not add when null has value =null

It forgives my English, I am brazileira... As to add the values in groups? Code: Father 1 -------- Son 1 -------- Grandson 1 -------- 5,00 Grandson 2 -------- 5,00 Grandson 3 -------- 5,00 Son 2 -------- Grandson 1 -------- 1,00 Grandson 2 -------- 1,00 Grandson 3 -------- 1,00 I want to add the values above that it is in the following way: Code:[code]Father 1 -------- 18,00 Son 1 -------- 15,00 Grandson 1 -------- 5,00 Grandson 2 -------- 5,00 Grandson 3 -------- 5,00 Son 2 -------- 3,00 Grandson 1 -------- 1,00 Grandson 2 -------- 1,00 Grandson 3 -------- 1,00 sql are grouped by father and son and have only the value of the grandson thanks