Posts by albsilva • 345 points

• 4

  votes

  1

  answer

  1886

  views

  Q: SQL: How to Count Values in Different Columns

  I would like to know how to count values in different columns. Generic example: ID - COLUNA1 - COLUNA2 1 - foo - Bar 2 - - Foo 3 - Qux - Bar 4 - Bar - I hope as a result count - value 2 - Foo 3 -…

  sql postgresql

  asked 8 years, 11 months ago albsilva 345

• 4

  votes

  1

  answer

  556

  views

  A: Problem with float vector

  The problem is that you are trying to make a sum of a variable float (cont) with a pointer (alg[y].nota). Remember that you modified your struct so that the variable would become a float vector.…

  c struct array float

  answered 9 years, 6 months ago albsilva 345

• 2

  votes

  2

  answers

  728

  views

  A: Error in converting JSF

  His method getAsObject is taking the string id, which in this case has the value "Select" and is trying to give a Long.valueof("Selecione") that causes a Exception. If you don’t want it to happen to…

  java jsf primefaces

  answered 9 years, 7 months ago albsilva 345

• 2

  votes

  1

  answer

  218

  views

  A: Hibernate Criterias - Group Dates

  I found the solution here: http://www.dclick.com.br/2007/11/14/implementando-criterion-para-utilizar-extract-do-oracle/ In the example it says Oracle, but it worked on postgresql as well.…

  java database hibernate criteria

  answered 9 years, 7 months ago albsilva 345

• 3

  votes

  1

  answer

  218

  views

  Q: Hibernate Criterias - Group Dates

  Currently I can group dates using Projections.sqlGroupProjection(). When my date field is in the same class as I create the Criteria, it works perfectly. The problem is when I create an alias, and…

  java database hibernate criteria

  asked 9 years, 7 months ago albsilva 345

• 6

  votes

  1

  answer

  5097

  views

  Q: How to group by month with SQL?

  I have a table, for example, with an attribute nome and data (for example only). I would like to generate a query that returns the amount of each row grouped by name and month: Nome Janeiro Fev…

  sql postgresql select-sql

  asked 10 years, 7 months ago albsilva 345

• 0

  votes

  1

  answer

  109

  views

  A: How to change the style of a vertical group in JGRAPHX?

  Solution: mxIGraphModel model = graph.getModel(); // start to change model model.beginUpdate(); mxGeometry geo = new mxGeometry(0, 0.5, PORT_DIAMETER, PORT_DIAMETER); // Because the origin is at…

  java

  answered 10 years, 9 months ago albsilva 345

• 0

  votes

  1

  answer

  109

  views

  Q: How to change the style of a vertical group in JGRAPHX?

  I am working on a UML project and using JGRAPHX, or mxGraph as you prefer. In this case, when I have a group of vertices, a dotted line is added to mark that that vertex is a group. How can I change…

  java

  asked 10 years, 10 months ago albsilva 345