Posts by albsilva • 345 points

8 posts

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, 5 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 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 3 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, 4 months ago albsilva 345