Posts by Fernando A.W. • 395 points
18 posts
-
0
votes1
answer184
viewsQ: MDX - Monthly Average Open by Date
I need a lot of help. I am working with MDX for graphics generation in Pentaho - CDE / Ctools. And I need to perform a series of filters that will be set by the user. The chart is a daily evolution,…
-
0
votes1
answer36
viewsA: Oracle - From/to Webfocus for Oracle
Problem solved using CTE structure. CTE - Oracle. I broke the query in two steps. Following are examples: TEC - Example 1 TEC - Example 2…
-
0
votes1
answer36
viewsQ: Oracle - From/to Webfocus for Oracle
Guys, I’d like some help. I have an ETL that was created in Webfocus, and I will migrate it to Oracle. I’ve done a lot of/stops, and would like an alternative to the following situations. In…
-
0
votes1
answer401
viewsA: Grouping data by age
Fellow. Your query is bringing more results because you are grouping by IDADE also. Simply remove it from the query, grouping it only by SEXO and PROFISSAO(GROUP BY). Follows: SELECT SEXO.SEXO,…
postgresqlanswered Fernando A.W. 395 -
3
votes1
answer625
viewsQ: Javascript - Soma e Group By em Array
I would like a tip/help. I’m working with a number of files JSON, and applying filters to them as the user advances in the system. So far so good, I managed to do it quietly using the .filter(). My…
-
0
votes1
answer367
viewsA: Javascript - Combination of variables - Filter
I was able to filter. Thinking calmly, it seemed even obvious. Living and learning. Here’s how I did it: //informação dos selects var cluster = $( "#CLUSTER-select" ).val(); var cliente_recente =…
-
2
votes1
answer50
viewsA: Querys MYSQL BELONGS
Renan, his IN will not work because you are passing more than one parameter to it, see the documentation IN. If I understand correctly, you can solve your problem with a SubQuery, in this way:…
-
3
votes1
answer367
viewsQ: Javascript - Combination of variables - Filter
I’m in need of a tip. I’m not a programmer, but I like to risk automating processes, sorry if the question is too basic. I’m working with the Google Maps API, and at a certain point I need to…
-
0
votes1
answer549
viewsA: Google Maps Api v3 - Working with 2 Json files
I was able to perform multiple filters using different bases. I followed the idea of this project Marker-Filtering-Google-Maps. That works in a very well organized way, I made some adaptations only,…
-
0
votes1
answer549
viewsQ: Google Maps Api v3 - Working with 2 Json files
I am creating a map, to present a lot of information, using google maps v3. I decided to work with 2 Json files, to fill the map. The first file contains the Latitude and Longitude information of…
-
0
votes4
answers860
viewsA: Select with indefinite amount of conditions
Friend. There is a simple solution to your problem. I’m using the MySql, but it is easy to change for your case. First, set the columns in which you want to fetch the value, imagining it to be more…
-
2
votes2
answers1749
viewsQ: Draw a pixel-by-pixel image
I’m trying to make a stupid little program but I’m not getting it. I want to randomly redraw a pixel-by-pixel image, doing this with multiple threads. I don’t know much about Java Swing, so I’m…
-
5
votes1
answer199
viewsA: Take values that were not used within the bd
Vitor, I’d do it this way. Would take the amount: MAX() from your table. Let’s say 100. Then it would generate a temporary table with values from 1 to 100. CREATE TABLE `incr` ( `Id` int(11) NOT…
-
1
votes3
answers1627
viewsA: How do you set zero or null in an SQL query of a date range, for those whose value does not exist?
Cold. As Wakin suggested and as I was writing. Make a schedule of dates, and from this one LEFT JOIN with your table. Here are two links with suggestions for creating this table: Generate Table…
-
1
votes1
answer665
viewsA: How to set value for Jquery Datatables filter?
Friend. In order for you to do this, you will have to pass the value of your field to the source that is loading the information. In my case I use PHP to load the information. In PHP Font there is a…
jqueryanswered Fernando A.W. 395 -
1
votes2
answers690
viewsA: Document.location.Reload() does not re-post equal to page refresh
Friend. I didn’t understand your question very well. I’m sorry if I’m wrong. You want to pass information via POST or GET. Have you considered using Ajax for this? $.ajax({ url:'minha_pagina.php',…
-
1
votes1
answer2722
viewsA: Click line from a jQuery Datatable and load a page with id information
Friend, you are using Jquery Datatables OK?? Datatables Since you don’t have a lot of details in your question, I assume it’s just to display the information, but if it’s not, it’s easy to change.…
-
1
votes1
answer87
viewsQ: Java Bounceball Bubble Movement - Error
I’m doing a Bounceball game, using iteration with the mouse pointer. But I’ve come across a problem I’m having trouble solving. The general idea is that, the bubbles move around the screen, and when…