Posts by Diorgenes Morais • 1 point
4 posts
-
-1
votes1
answer411
viewsA: Input number with coin mask
I have a code suggestion so you can adapt to your project. This code puts the mask the way you want it. var Erp = Erp || {}; Erp.Formatter = (function() { function Formatter() { this.configMask = {…
javascriptanswered Diorgenes Morais 1 -
0
votes1
answer33
viewsA: Left Join with Two Counts from the same table
Jota use a sub-volume (2nd to 5th line) to calculate the error: SELECT u.iduser, COUNT(p.idpalpite) acertos, (SELECT COUNT(e.idpalpite) FROM palpites e LEFT usuarios us ON us.iduser = e.iduser WHERE…
mysqlanswered Diorgenes Morais 1 -
0
votes1
answer197
viewsA: Sort by year SQL data
Well, in Mysql I would do so (use as a base for another bank). Your query should return all fields through *, and through the Year function return only the year as a field. Note: Year is a Mysql…
-
0
votes1
answer383
viewsA: How to mount a generic query using jpa nativequery
Felipe, When creating a nativeQuery think about how you would do it directly in the database, that is, what works in your SQL will work in createNativeQuery. It works: em.createNativeQuery("select…